The Ones We Watch

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

We run an observability platform. Among the services that have at least one alert wired up in alert_events, total up the error occurrences each has logged and list them busiest first.

Summary

Only the services still under watch count. Rank them by where the errors gather.

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