Can you please tell me the number of routes with the destination airport Italy?
select count ( * ) from routes as t1 join airports as t2 on t1.dst_apid = t2.apid where t2.country = 'Italy'
Can you please tell me the number of routes with the destination airport in Italy operated by the airline with the 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'
What are the source airports of those routes?
select t1.src_ap 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'