Loading…
Every scheduled flight ends one of three ways: it is cancelled, it is diverted to another airport, or it completes.
Return two columns: outcome (cancelled, diverted, or completed) and flight_count. Order by from highest to lowest.
flight_countCreate 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.