The Path Not Taken

A hard SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain

SQL

Difficulty

hard

Seniority

L5

Interview Prompt

The product team is measuring organic adoption of the new editor, which shows up in page views under the URL 'new_editor', while the old one appears as 'classic_editor'. Find the users who reached the new editor without ever opening the classic editor before their first new editor visit.

Summary

Some found the new path without ever walking the old one.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision