The Price of a Tap

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

Marketing has been running promotional push campaigns whose names all contain 'promo', and wants to know how hard each one worked to earn a customer. For every promo campaign, broken out by year, find how many notifications it took to earn a single open: total notifications sent divided by the number that were opened.

Summary

The campaign fired thousands of pushes. Find what each open really cost.

Practice This Problem

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