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
Find the cities which have exactly two airports
assistant
SELECT city FROM airports GROUP BY city HAVING COUNT( * ) = 2;
human
What location airports is near by me has two airports? | What do you mean by near by you? Sorry, We cannot answer this. | what is the name of airport in the country Papua New Guinea
assistant
SELECT name FROM airports WHERE country = 'Papua New Guinea';
human
what is the elevation of Madang Airport?
assistant
SELECT elevation FROM airports WHERE name = 'Madang Airport';
human
What is the elevation of Goroka Airport
assistant
SELECT elevation FROM airports WHERE name = "Goroka Airport" ;