Loading interview...

Price Rank

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

Interview Prompt

The catalog team wants competitive price positioning inside each category. Within each category, rank products by price with the most expensive at position 1, and let ties share a position. Skip rows where price is NULL. Return the product_name, category, price, and its position.

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