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

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 entry, show svc_name, deploy_at, dur_secs, a running total of dur_secs within each service (ordered by deploy_at), and an overall duration tier using NTILE(3) across all deploys ordered 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.