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
what is the lowest elevation of all airports?
assistant
SELECT MIN( elevation ) FROM airports;
human
what is the name of that airport?
assistant
SELECT name FROM airports ORDER BY elevation LIMIT 1;
human
also show the city and country where it is located.
assistant
SELECT name , city , country FROM airports ORDER BY elevation LIMIT 1 ;