Table: big_day_out_lineups_2
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

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

Question: Which Melbourne has an Auckland of no, and a Gold Coast of no?
SQL: SELECT "melbourne" FROM big_day_out_lineups_2 WHERE "auckland" = 'no' AND "gold_coast" = 'no'

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

Question: Which Sydney has a Perth of no, a Melbourne of yes, and a Gold Coast of no?
SQL: SELECT "sydney" FROM big_day_out_lineups_2 WHERE "perth" = 'no' AND "melbourne" = 'yes' AND "gold_coast" = 'no'

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

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