Find the number of routes from the United States.
select count(*) from routes where src_apid in (select apid from airports where country = 'United States')
how many of them end up in 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')