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

L3

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.

Summary

Searched but never clicked.

Practice This Problem

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