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 the route id of the destination airport id 2990?
assistant
SELECT rid FROM routes WHERE dst_apid = '2990';
human
Show the number of different airports which are the destinations of the American Airlines?
assistant
SELECT COUNT( DISTINCT dst_apid ) FROM airlines AS T1 JOIN routes AS T2 ON T1.alid = T2.alid WHERE T1.name = "American Airlines" ;