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

L5

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.

Summary

Yesterday versus today. What moved?

Practice This Problem

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