For each deploy log, show svc_name, deploy_at, dur_secs, a running total of dur_secs within each ser

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

Domain

SQL

Difficulty

medium

Problem

For each deploy log, show svc_name, deploy_at, dur_secs, a running total of dur_secs within each service by deploy_at, and an overall duration tier (3 buckets) across all deploys by dur_secs descending.

Practice This Problem

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