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

L4

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.

Summary

Which ad format drives the most revenue?

Practice This Problem

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