Two Names on the Ledger
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L4
Interview Prompt
Finance is reconciling revenue for two customers, alice and aaron42, and wants to see how their combined spend builds up transaction by transaction. Going through their transactions from the earliest ID to the latest, return each transaction's ID, the user, its amount, and the combined revenue accumulated through that transaction.
Summary
Two accounts. One ledger. Watch the spend stack up.
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