No Dead Months

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

We're building a leaderboard of ad campaigns, but a campaign only earns a spot if it drew at least one click in every calendar month it was active. Among the campaigns that clear that bar, order them by their single heaviest month of revenue, lowest peak first, and return just the campaign name.

Summary

Every month it ran, it landed a click. Among those, find the ones whose worst month of spend stayed lowest.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.