Loading interview...

Avg Alerts by Severity

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
mid, senior

Interview Prompt

The incident response team only trusts alert data from services that also appear in the health check system. Among those services, for any service-severity combination that fired more than once in 2026, first count the alerts per combination, then compute the average of those counts for each severity level, rounded to one decimal place.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your sql solution with real code execution
  4. Get instant feedback and a hire/no-hire decision