Return on a Glance

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The marketing analytics team is benchmarking how much revenue each ad campaign earns per impression, where every impression served counts toward the average even the ones that brought in nothing. Give each campaign that figure, highest first.

Summary

Every impression costs something. Find the campaigns earning it back.

Practice This Problem

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