DataDriven
LearnPracticeInterviewDiscussDailyJobs

After Hours API Calls

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain
SQL
Difficulty
medium
Seniority
L3

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • SQL Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons