Ad Clickers
An easy SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L4
Interview Prompt
Ad impressions are logged one row per ad served, with a click flag and the revenue it earned. For every user who clicked at least one ad, show their username and the total revenue those clicks brought in, highest contributor first.
Summary
Who clicked? What did they spend?
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision