The Threshold

A medium 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

medium

Seniority

L4

Interview Prompt

Which pages in `page_views` show up most often among each visitor's first three views? Return the pages with the three highest appearance counts, along with each page's count.

Summary

Every visit begins with three doors. Find the ones most often opened.

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