Who's Holding Up Traffic
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
The API product team wants to understand typical daily traffic per endpoint during June 2026. For each endpoint, what was the average number of unique users hitting it on a given day that month?
Summary
Some endpoints carry the product. Others are barely touched.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision