Schema: CREATE TABLE airport (id VARCHAR, country VARCHAR, city VARCHAR, name VARCHAR)
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