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
Show me the destination details of John F Kennedy International Airport
assistant
SELECT dst_apid , dst_ap FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.dst_apid WHERE T1.name = 'John F Kennedy International Airport';
human
Show me the routes details | do you mean the routes details of John F Kennedy International Airport? | Yes
assistant
SELECT * FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.dst_apid WHERE T1.name = 'John F Kennedy International Airport';
human
Show me the number of routes that have destination John F Kennedy International Airport
assistant
SELECT COUNT( * ) FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.dst_apid WHERE T1.name = "John F Kennedy International Airport" ;