Loading interview...

Top Error-Service Pair

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

During an incident postmortem, you need to find the error-service combination responsible for the most resolved incidents. Build an identifier by combining the error type and service name from the error tracker, then count how many unique errors that combination produced where the corresponding alert was eventually resolved. Return only the top-ranked combinations, including ties, sequenced alphabetically.

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