human
Schema:
routes (rid, dst_apid, dst_ap, src_apid, src_ap, alid, airline, codeshare)
airports (apid, name, city, country, x, y, elevation, iata, icao)
airlines (alid, name, iata, icao, callsign, country, active)
Please answer with SQL.
assistant
Sure, I understand.
human
Can you list the number of airports whose names contain the word 'International'?
assistant
SELECT COUNT( * ) FROM airports WHERE name LIKE '%International%';
human
What is the most common country of all of those airports?
assistant
SELECT country FROM airports GROUP BY country ORDER BY COUNT( * ) DESC LIMIT 1;
human
What is the greatest elevation of all of those airports?
assistant
SELECT MAX( elevation ) FROM airports ;