Ebb and Flow
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
A finance team tracks revenue momentum by watching how each month stacks up against the one before it. Total each month's transaction revenue and show how it moved, in percent, from the immediately preceding month.
Summary
The rise and fall of revenue, one month against the last.
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