Status Report
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
- L3
Interview Prompt
Our per-status profit report has been counting orders that were never tagged to a sales region. From the orders table, show each status that has real volume behind it, with its order count and average profit, most profitable first.
Summary
Where are orders getting stuck?
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