WHAT IS THE AIRPORT NAME OF GORKA CITY IN AIRPORT TABLE?
select name from airports where city = 'Goroka'
MADANG CITY SITUATED IN WHICH COUNTRY? IN AIRPORT TABLE
select country from airports where city = 'Madang'
* I have left the chat *
select distinct rid from routes where alid = '410'