Losing Altitude

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 ad campaigns lost momentum between June and October of 2026. Within each of those two months, campaigns are placed by how many of their impressions were clicked, most first; surface the campaigns that sat lower in October than they did in June.

Summary

Two months apart, the same campaigns. Find the ones that slipped.

Practice This Problem

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