Table: big_day_out_lineups_7
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: yes or no for the auckland with a yes for sydney, no for perth, yes for melbourne and yes for the gold coast?
SQL: SELECT "auckland" FROM big_day_out_lineups_7 WHERE "sydney" = 'yes' AND "perth" = 'no' AND "melbourne" = 'yes' AND "gold_coast" = 'yes'

Question: yes or no for the adelaide with no for auckland, yes for melbourne, yes for the gold coast?
SQL: SELECT "adelaide" FROM big_day_out_lineups_7 WHERE "auckland" = 'no' AND "melbourne" = 'yes' AND "gold_coast" = 'yes'

Question: yes or no for the gold coast with yes for melbourne, yes for adelaide, yes for auckland?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_7 WHERE "melbourne" = 'yes' AND "adelaide" = 'yes' AND "auckland" = 'yes'

Question: yes or no for the melbourne with yes for gold coast, yes for adelaide, no for auckland?
SQL: SELECT "melbourne" FROM big_day_out_lineups_7 WHERE "gold_coast" = 'yes' AND "adelaide" = 'no' AND "auckland" = 'no'

Question: yes or no for the sydney with yes for melbourne, no for perth, no for auckland and no for gold coast?
SQL: SELECT "sydney" FROM big_day_out_lineups_7 WHERE "melbourne" = 'yes' AND "perth" = 'no' AND "auckland" = 'no' AND "gold_coast" = 'no'

Question: yes or no for the melbourne that has no for adelaide, no for gold coast?
SQL: SELECT "melbourne" FROM big_day_out_lineups_7 WHERE "adelaide" = 'yes' AND "gold_coast" = 'no'