Find the number of routes 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')