Table: big_day_out_lineups
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: Name the melbourne with perth, adelaide and auckland of no with sydney of yes
SQL: SELECT "melbourne" FROM big_day_out_lineups WHERE "perth" = 'no' AND "adelaide" = 'no' AND "auckland" = 'no' AND "sydney" = 'yes'

Question: Name the gold coast which has an auckland of no and melbourne of yes
SQL: SELECT "gold_coast" FROM big_day_out_lineups WHERE "auckland" = 'no' AND "melbourne" = 'yes'

Question: Name the sydney with perth of no, adelaide of no with melbourne of yes and gold coast of yes
SQL: SELECT "sydney" FROM big_day_out_lineups WHERE "perth" = 'no' AND "adelaide" = 'no' AND "melbourne" = 'yes' AND "gold_coast" = 'yes'

Question: Name the Adelaide for Sydney of yes and Perth of yes
SQL: SELECT "adelaide" FROM big_day_out_lineups WHERE "sydney" = 'yes' AND "perth" = 'yes'

Question: Name the melbourne for adelaide of no with auckland of yes and gold coast of yes
SQL: SELECT "melbourne" FROM big_day_out_lineups WHERE "adelaide" = 'no' AND "auckland" = 'yes' AND "gold_coast" = 'no'