SELECT

StatusID,

Description,

COUNT$($StatusID$)$ AS NumFlights

FROM

FlightStatus

GROUP BY

StatusID, Description

ORDER BY

StatusID;