-- Database schema
| airport : id [ INT ] primary_key , City [ TEXT ] , Country [ TEXT ] , IATA [ TEXT ] , ICAO [ TEXT ] , name [ TEXT ] | operate_company : id [ INT ] primary_key , name [ TEXT ] , Type [ TEXT ] , Principal_activities [ TEXT ] , Incorporated_in [ TEXT ] , Group_Equity_Shareholding [ INT ] | flight : id [ INT ] primary_key , Vehicle_Flight_number [ TEXT ] , Date [ TEXT ] , Pilot [ TEXT ] , Velocity [ INT ] , Altitude [ INT ] , airport_id [ INT ] flight.airport_id = airport.id , company_id [ INT ] flight.company_id = operate_company.id |
-- -- 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;