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
- L3
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.
Summary
How good are the search results?
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