How many routes go from the United States to Canada?
select count(*) from routes where dst_apid in (select apid from airports where country = 'Canada') and src_apid in (select apid from airports where country = 'United States')