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

Domain

SQL

Difficulty

hard

Seniority

L5

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.

Summary

Flagged the most. Resolved how?

Practice This Problem

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