Loading…
For each origin airport, find the destination with the highest share of late arrivals.
A flight is late when arrival_delay_minutes is 15 or more. Use only flights that have an arrival delay. Return origin_airport, dest_airport, arrivals_measured, and (late arrivals divided by measured arrivals, rounded to 3 decimals), one row per origin. If two destinations tie, keep the one that comes first alphabetically. Order by .
late_rateorigin_airportCreate a free account to save your progress and reveal the worked answer for this free exercise. The complete practice library is available with Practice Pass or Mastery.