Extreme Category Totals
A medium 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
- medium
- Seniority
- L5
Interview Prompt
For the current calendar year, we're comparing product categories by their total sales. Combine each transaction with its product to get the category, then return the three categories with the highest total sales and the three with the lowest.
Summary
The highest and the lowest. Both are interesting.
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