Above Average Product Prices
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The finance team defines a product's base price as the lowest transaction amount ever recorded for it, and wants to flag the products whose base price runs above the average base price across all products. Return each flagged product's ID and its base price.
Summary
Some products cost more than they should.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision