Loading interview...

First Half of Page Views

A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
SQL
Difficulty
medium
Seniority
mid

Interview Prompt

Retrieve the first half of all page view records based on the total row count. Include each record's row number alongside all view details (view ID, page URL, user ID, referrer, duration in milliseconds, device, and viewed-at timestamp). Results should be ordered by view ID.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision