The Standings
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
Strategy wants a full financial picture per product category. For each category, give the total revenue and total units sold, and assign it a standing by revenue with the biggest earners first. Return the category, its revenue, its units, and its standing.
Summary
Every category earns its place on the board. Find where each one lands.
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