On Their Way Out

An easy 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
easy
Seniority
L4

Interview Prompt

We're compiling the users who signed up but never really engaged. Add up the pages each user viewed across all of their sessions, and return those users alongside that total.

Summary

They signed up. They never really showed up.

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