CREATE TABLE flight (id NUMBER, vehicle_flight_number CLOB, date CLOB, pilot CLOB, velocity NUMBER, altitude NUMBER, airport_id NUMBER, company_id NUMBER)
CREATE TABLE airport (id NUMBER, city CLOB, country CLOB, iata CLOB, icao CLOB, name CLOB)
CREATE TABLE operate_company (id NUMBER, name CLOB, type CLOB, principal_activities CLOB, incorporated_in CLOB, group_equity_shareholding NUMBER)

List the id, country, city and name of the airports ordered alphabetically by the name.
SELECT id, country, city, name FROM airport ORDER BY name
SELECT "id", "country", "city", "name" FROM "airport" ORDER BY "name"