Deployment Duration by Status

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

During an incident retro, the SRE lead asked how much wall-clock time each service spends deploying, split by outcome. Show the total deployment duration in seconds for every service-status combination, listed alphabetically by service.

Summary

Fast deploys versus slow ones. By outcome.

Practice This Problem

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