Click Rate

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

Domain

SQL

Difficulty

medium

Problem

The marketing team is auditing ad campaign performance before next quarter's budget allocation. For each campaign, they want to see the click-through rate as a percentage of impressions, the total revenue attributed to the campaign, and how many impressions were served. Only surface campaigns with more than one in five impressions resulted in a click , anything below that isn't worth renewing. Rank from highest click-through rate to lowest.

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.