It would also be interesting to order flights by giving them a sequence number based on time, by carrier.
For instance, assuming
flight_id increments with each additional flight, we could use the following query to view flights by carrier, flight id, and sequence number:
SELECT carrier, id,
FROM flights f
WHERE f.id < flights.id
AND f.carrier=flights.carrier) + 1