Users With and Without Ad Clicks
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L4
Interview Prompt
An ads team wants to see how click engagement splits across the whole user base. Count how many users have at least one clicked ad impression versus how many have none, showing each group with its user count.
Summary
Clicked an ad versus never clicked. The split.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision