Database: flight_company
Question: List the id, country, city and name of the airports ordered alphabetically by the name.
SQL:
SELECT id ,  country ,  city ,  name FROM airport ORDER BY name