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

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

A stakeholder flagged that some campaigns lost momentum between June 2025 and October 2025. Rank each campaign by the number of impressions where clicked is 1 in each of those two months, then surface just the campaign names whose ranking position worsened (higher rank number) from June to October.

Summary

Two months, many countries. Who moved up? Who fell?

Practice This Problem

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