Loading interview...

Search Algorithm Rating

A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
hard
Seniority
junior, mid

Interview Prompt

We need a search quality score for each query. Assign a rating: 1 if no result was clicked, 2 if a result was clicked but the top clicked position was outside the top 3, and 3 if a result was clicked in positions 1 through 3. Show each query ID and its rating.

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