Upvote Percentage by Age Cohort
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
- L5
Interview Prompt
The search team is comparing search success between brand-new and tenured users. A user counts as 'new' if their signup is within 30 days of the most recent signup on file; everyone else is 'existing'. A search counts as successful when the user clicked through to a result. For each segment, show the segment label, total searches, successful searches, and the success rate as a decimal. Sort alphabetically by segment.
Summary
New users versus existing. The upvote gap.
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