Top Flagged Campaign Resolutions

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

Domain

SQL

Difficulty

hard

Seniority

senior, staff

Problem

Find the ad campaign(s) that received the most user-reported alerts. Among those top campaigns, how many alerts were resolved? Match alert_events to ad_impressions where alerts fired in the same hour as an impression. Ignore alerts without a valid alert_id. Return the campaign and resolved count.

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.