Daily Net Revenue
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
- L4
Interview Prompt
Product 1001 needs a daily revenue reconciliation between January 1 and April 30, 2025. Positive transaction amounts are purchases and negative values are refunds. Include all qualifying purchases in that date range, plus any refunds for the same product regardless of date.
Summary
Net revenue, day by day. Refunds included.
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