Deploy Velocity

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

Domain

SQL

Difficulty

hard

Problem

The release manager wants to track how frequently each service deploys. Within each svc_name in deploy_logs, order by deploy_at and measure the gap in days between each consecutive pair of deploys. Average those gaps per service. Return the svc_name and its average gap in days.

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.