Table: airports_8
Columns: city
state_territory
iata
icao
airport
begin

Question: Which airport has perth as the city?
SQL: SELECT "airport" FROM airports_8 WHERE "city" = 'perth'

Question: Which city has tasmania as the state/territory and a ICAO of ymhb?
SQL: SELECT "city" FROM airports_8 WHERE "state_territory" = 'tasmania' AND "icao" = 'ymhb'

Question: Which airport has an ICAO of ybcg?
SQL: SELECT "airport" FROM airports_8 WHERE "icao" = 'ybcg'

Question: What is the IATA that has new south wales as the state/territory beginning on july 2009?
SQL: SELECT "iata" FROM airports_8 WHERE "state_territory" = 'new south wales' AND "begin" = 'july 2009'

Question: What IATA has queensland as the state/territory and an ICAO of ybrk?
SQL: SELECT "iata" FROM airports_8 WHERE "state_territory" = 'queensland' AND "icao" = 'ybrk'

Question: What begin has victoria as the state/territory and a ICA0 of ymml?
SQL: SELECT "begin" FROM airports_8 WHERE "state_territory" = 'victoria' AND "icao" = 'ymml'