Break Through

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The marketing team is auditing ad campaigns before next quarter's budget is set, and a campaign is only worth renewing when more than one in five impressions turns into a click. Surface those campaigns with their click-through rate and the revenue they brought in, highest click-through rate first.

Summary

A click is the only vote that counts.

Practice This Problem

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