-- Database schema
| flight : flno [ INT ] primary_key , origin [ TEXT ] , destination [ TEXT ] , distance [ INT ] , departure_date [ TEXT ] , arrival_date [ TEXT ] , price [ INT ] , aid [ INT ] flight.aid = aircraft.aid | aircraft : aid [ INT ] primary_key , name [ TEXT ] , distance [ INT ] | employee : eid [ INT ] primary_key , name [ TEXT ] , salary [ INT ] | certificate : eid [ INT ] primary_key certificate.eid = employee.eid , aid [ INT ] certificate.aid = aircraft.aid |
-- -- Show flight number, origin, destination of all flights in the alphabetical order of the departure cities.

SELECT flno ,  origin ,  destination FROM Flight ORDER BY origin;