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
Name the airport in Madang city?
assistant
SELECT name FROM airports WHERE city = 'Madang';
human
How many airports are in Papua New Guinea country?
assistant
SELECT COUNT( * ) FROM airports WHERE country = 'Papua New Guinea';
human
Find the number of routes with destination airports in Italy?
assistant
SELECT COUNT( * ) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid = T2.apid WHERE T2.country = 'Italy';
human
What is the elevation of Mount Hagen Kagamuga Airport?
assistant
SELECT elevation FROM airports WHERE name = "Mount Hagen Kagamuga Airport" ;