Loading...

Deployment Failure Impact

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

Domain
SQL
Difficulty
medium
Seniority
mid

Problem

After a string of rollbacks, leadership asked how much deployment capacity each service loses to failures. For each service, show what percentage of its deployments failed and what percentage of its total deployment time was consumed by those failures.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.