The Latest Transaction Per Product
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
The catalog dashboard needs each product paired with its most recent sale. For every product, show the product details alongside the most recent transaction amount and date. Some products have hundreds of transactions, so only the latest should appear.
Summary
Every product has a last sale. When was it?
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