how many airports does each country have?
select count(*), country from airports group by country
how many does Canada have?
select count(*) from airports where country = 'Canada'
what is the total number of routes that end there?
select count(*) from airports as t1 join routes as t2 on t1.apid = t2.dst_apid where country = 'Canada'