Campaign Match Rate

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

Domain

SQL

Difficulty

easy

Problem

An ad_impression row 'matches' when its ad_campaign value appears anywhere as a campaign value in push_notifs. Return the percentage of ad_impressions rows (out of all ad_impressions rows) that match. Return a single number (0 to 100).

Practice This Problem

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