Best Day for Ad Revenue

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

Domain

SQL

Difficulty

medium

Seniority

L5

Problem

The ad team wants to see which calendar days carry the strongest click premium: the gap between average revenue on clicked impressions and on non-clicked ones. Break the numbers down by day of the month (1 through 31), and for each day report the overall average revenue, the biggest single-impression revenue, and that click premium, widest premium first.

Summary

Some days of the month convert far better than others.

Practice This Problem

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