Heavy Ad Exposure

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

Domain

SQL

Difficulty

medium

Seniority

L5

Problem

A user qualifies as heavy ad exposure if they have 3 or more impressions from a single campaign, or if they have 5 or more total impressions spread across at least 2 different campaigns. Return the qualifying user IDs.

Summary

Saturated with ads. Is it too much?

Practice This Problem

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