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 identify which day of the month shows the strongest click premium: the biggest gap between average revenue on clicked impressions versus non-clicked ones. For each calendar day (1 through 31), compute the overall average revenue and the peak single-impression revenue. Return only the one day where the click premium is widest.

Summary

One day of the month outperforms the rest.

Practice This Problem

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