CREATE TABLE routes (dst_apid VARCHAR2, alid VARCHAR2)
CREATE TABLE airlines (alid VARCHAR2, name VARCHAR2)
CREATE TABLE airports (apid VARCHAR2, country VARCHAR2)

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'