Loading...
Campaign Revenue by Click Channel
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
The ad team wants a revenue breakdown by campaign showing how much came from clicked impressions versus non-clicked ones. For each campaign, show the total revenue and the percentage split between clicked and non-clicked, listed alphabetically by campaign.
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.