CREATE TABLE airports (apid NUMBER, name CLOB, city CLOB, country CLOB, x NUMBER, y NUMBER, elevation NUMBER, iata CLOB, icao CLOB)
CREATE TABLE routes (rid NUMBER, dst_apid NUMBER, dst_ap CLOB, src_apid NUMBER, src_ap CLOB, alid NUMBER, airline CLOB, codeshare CLOB)
CREATE TABLE airlines (alid NUMBER, name CLOB, iata CLOB, icao CLOB, callsign CLOB, country CLOB, active CLOB)

Return the number of routes with destination airport in Italy operated by the airline with name 'American Airlines'.
SELECT COUNT(*) FROM routes AS T1 JOIN airports AS T2 ON T1.dst_apid = T2.apid JOIN airlines AS T3 ON T1.alid = T3.alid WHERE T2.country = 'Italy' AND T3.name = 'American Airlines'
SELECT COUNT(*) FROM "routes" "T1" JOIN "airports" "T2" ON "T1"."dst_apid" = "T2"."apid" AND "T2"."country" = 'Italy' JOIN "airlines" "T3" ON "T1"."alid" = "T3"."alid" AND "T3"."name" = 'American Airlines'