Pipeline Recovery by Priority

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

For each pipeline run that completed successfully after January 1, 2026, find every batch job that started on the same calendar day. Show the pipeline name and the batch job priority, along with the minimum, average, and maximum pipeline duration in seconds for each pipeline name and priority combination.

Summary

Recovery time, priority by priority.

Practice This Problem

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