After Hours API Calls
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
- L3
Interview Prompt
The compliance team is auditing API activity outside business hours for December 2026. Business hours are Monday through Friday, 09:00 to 16:00. All weekend calls and calls on December 25th and 26th count as out-of-hours regardless of time. Return the total count of out-of-hours calls as a decimal value.
Summary
The office is dark. The API is not.
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