Deploy Velocity Swings

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

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, give the percentage change in deployment count from the prior month, leaving out each service's first month since it has 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 checks it automatically.