Table: big_day_out_cities
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: Which gold Coast has a Melbourne of yes, a Perth of yes, an Auckland of no, and a Sydney of no?
SQL: SELECT "gold_coast" FROM big_day_out_cities WHERE "melbourne" = 'yes' AND "perth" = 'yes' AND "auckland" = 'no' AND "sydney" = 'no'

Question: Which Adelaide has an Auckland of no and a Melbourne of no?
SQL: SELECT "adelaide" FROM big_day_out_cities WHERE "auckland" = 'no' AND "melbourne" = 'no'

Question: Which Sydney has a Gold Coast of yes, an Adelaide of no, and an Auckland of yes?
SQL: SELECT "sydney" FROM big_day_out_cities WHERE "gold_coast" = 'yes' AND "adelaide" = 'no' AND "auckland" = 'yes'

Question: Which Sydney has a Perth of no, an Adelaide of yes, and a Gold Coast of no?
SQL: SELECT "sydney" FROM big_day_out_cities WHERE "perth" = 'no' AND "adelaide" = 'yes' AND "gold_coast" = 'no'

Question: Which Adelaide has a Sydney of yes, a Perth of no, a Melbourne of yes, and an Auckland of no?
SQL: SELECT "adelaide" FROM big_day_out_cities WHERE "sydney" = 'yes' AND "perth" = 'no' AND "melbourne" = 'yes' AND "auckland" = 'no'

Question: Which Melbourne has a Perth of yes, and an Auckland of yes?
SQL: SELECT "melbourne" FROM big_day_out_cities WHERE "perth" = 'yes' AND "auckland" = 'yes'