Loading...
Daily Metric Percentage Change
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- senior
Problem
After a deploy incident, the release manager wants to see day-over-day deployment velocity changes per service. For each service and deploy date, compute the percentage change in deployment count from the previous day. Exclude the first day for each service since there's no baseline. Round to 2 decimal places.
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.