First Among Results
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
- L4
Interview Prompt
The search relevance team wants to know whether longer queries push shoppers onto the very first hit. In `search_queries`, `clicked_result` holds the position of the result a shopper clicked, where 1 is the top result. For each search term length, show how many searches there were and how many landed on that top result.
Summary
When queries run long, does the top hit still win?
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