The Ones We Watch

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

We run an observability platform, and the services worth tracking are the ones the team still monitors: every service with at least one alert wired up in alert_events. Among those, total up the error occurrences each has logged and list them from the busiest down to the quietest.

Summary

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

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.