Loading interview...

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
mid

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision