Pipeline Throughput Ratio

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

Domain

SQL

Difficulty

easy

Seniority

L5

Problem

The data platform team is measuring pipeline efficiency as the ratio of rows output to rows input per run, rounded to 4 decimal places. Show each run's pipeline name, start time, and throughput ratio, ordered by pipeline name and start time.

Summary

Compute current-to-initial value ratio per period.

Practice This Problem

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