Top 2 Busiest API Slots

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

A reliability team is triaging which failures crowd the day. Split each HTTP status's failed calls into Morning, Early Afternoon and Late Afternoon by the hour they happened, and return the status-and-slot pairs with the three highest failure counts.

Summary

Two time slots per week. The busiest.

How This Interview Works

1. Read the vague prompt (just like a real interview)
2. Ask clarifying questions to the AI interviewer
3. Write and run your SQL against a real database
4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision