Loading…
Each late flight splits its arrival delay across five cause columns. Turn those columns into rows.
Return cause (carrier, weather, 'national air system', security, 'late aircraft') and delay_minutes (the total for that cause). Order by delay_minutes from highest to lowest.
Create 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.