Adopters Before Migration
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
- L5
Interview Prompt
The product team is measuring organic adoption of the new editor versus the classic editor. In the page views data, visits to the new editor appear under the URL 'new_editor' and visits to the classic editor under 'classic_editor'. Identify users who visited the new editor but had never visited the classic editor before their first new editor visit. Return their user IDs.
Summary
They used the old feature. Did they ever touch the new one?
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