Services With Most Checks in 2025
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L4
Interview Prompt
The compliance team wants to find services whose busiest year for health checks is 2026. For every service whose 2026 check count matches or beats every other year on record for that service, show the service name and its 2026 check count. Sort from highest count down, breaking ties alphabetically.
Summary
Last year's most-checked services.
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