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
- L4
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.
Summary
Half the data. The first half.
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