Loading...
Unclicked Searches by Campaign
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- junior, mid
Problem
Our ad platform logs search queries with campaign tags. Count how many search queries were performed per ad campaign, broken down by whether the user clicked a result or not. Show the campaign, click status, and event 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.