Recent Price Drops
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
A downstream consumer flagged stale product data. Pull all products that either had a transaction recorded within the last day, or are currently marked as in stock. Return unique product IDs and names, no duplicates.
Summary
The price just dropped. Who noticed?
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