Select Exactly Two Runs Per Pipeline

Exercise brief

Understand the request

Benchmarking coordinator A fixed-size benchmark sample requires exactly two runs from each pipeline even when the cutoff value is tied.

A fixed-size benchmark sample requires exactly two runs from each pipeline even when the cutoff value is tied. Use deterministic ROW_NUMBER per pipeline and keep row_num at most 2.

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

WITH ranked AS (SELECT run_id, pipeline_name, rows_loaded, ROW_NUMBER() OVER (PARTITION BY pipeline_name ORDER BY rows_loaded DESC, run_id) AS row_num FROM pipeline_runs) SELECT pipeline_name, run_id, rows_loaded FROM ranked WHERE row_num <= 2 ORDER BY pipeline_name, row_num;

Expected result

Use this output to verify values, aliases, ordering, and row count.