Name the airport in Madang city?
select name from airports where city = 'Madang'
How many airports are in Papua New Guinea country?
select count ( * ) from airports where country = 'Papua new Guinea'
Find the number of routes with destination airports in Italy?
select count ( * ) from routes as t1 join airports as t2 on t1.dst_apid = t2.apid where t2.country = 'Italy'
What is the elevation of Mount Hagen Kagamuga Airport?
select elevation from airports where name = 'Mount hagen kagamuga Airport'