Deploy Velocity Swings

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

Domain

SQL

Difficulty

medium

Seniority

L5

Problem

After a release retro, the manager wants month-over-month deployment velocity per service. For each service and month, compute the percentage change in deployment count from the previous month. Exclude each service's first month (no baseline). Round to 2 decimals.

Summary

Month to month, who sped up and who stalled.

Practice This Problem

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