Loading interview...

Campaign Match Rate

A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
easy

Interview Prompt

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).

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision