Categories With Mixed Price Tiers
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
- L4
Interview Prompt
A recommendation model needs product categories that span both high-value (over $500) and lower-value transactions, since mixing price tiers improves diversity. Which categories have seen both kinds of transactions? Return just the category name.
Summary
Users who cross content types.
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