Service Uptime Minutes

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
L5

Interview Prompt

The reliability team wants to know, per service, how many hours its still-open alerts have been firing as of 2026-09-12. Their onboarding review only covers alerts that fired within 180 days of the service's earliest health check.

Summary

Status changed. How long was it actually up?

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