Loading...
Holiday Promo Campaign Click Year
A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- junior
Problem
The ad impressions table logs campaign-level clicks. Find the year in which the HOLIDAY_PROMO campaign had at least 1 total click. Roll up impressions by year for the HOLIDAY_PROMO campaign only. Return the qualifying fiscal year.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.