task Gaps & islands · hard

Three late legs in a row

For January 2025, consider each aircraft’s operated (not cancelled, not diverted) flights per flight_date in scheduled order. Return tail_number, flight_date, first_departure and late_legs for every run of at least 3 consecutive flights arriving more than 15 minutes late.

what to return

Columns

tail_numberflight_datefirst_departurelate_legs in this order

Rows

710 rows · any order

Skill

Detect consecutive runs of a condition in an ordered sequence. Refresher: Rolling averages & missing dates →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

U.S. Flights dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.