Pipeline Overhead by Environment

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The data platform team wants to compare throughput overhead between pipelines that finished successfully and those still running. For each of those two states, work out the average size of the gap between rows read in and rows written out, then report how far apart those two averages are as a single number. Status is recorded with inconsistent capitalization, so spellings like 'success' and 'Success' should be counted as the same state.

Summary

Production overhead versus staging.

Practice This Problem

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