Table: airports
Columns: city
country
iata
icao
airport

Question: Which ICAO's IATA is ath?
SQL: SELECT "icao" FROM airports WHERE "iata" = 'ath'

Question: Which country's city is Sendai?
SQL: SELECT "country" FROM airports WHERE "city" = 'sendai'

Question: Which ICAO's city is Manchester?
SQL: SELECT "icao" FROM airports WHERE "city" = 'manchester'

Question: Which airport is in Saudi Arabia when the ICAO is oejn?
SQL: SELECT "airport" FROM airports WHERE "country" = 'saudi arabia' AND "icao" = 'oejn'

Question: Which IATA's ICAO is rjss?
SQL: SELECT "iata" FROM airports WHERE "icao" = 'rjss'

Question: Which country features Adelaide Airport?
SQL: SELECT "country" FROM airports WHERE "airport" = 'adelaide airport'