how many routes are operated by the airline with name 'American Airlines'.
select count(*) from routes as t1 join airlines as t2 on t1.alid = t2.alid where t2.name = 'American Airlines'
how many of them list the US as the destination?
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 = 'United States' and t3.name = 'American Airlines'
how about for Italy?
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'