Table: big_day_out_lineups
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: what is the Sydney that has Adelaide, Gold Coast, Melbourne, and Auckland are all yes?
SQL: SELECT "sydney" FROM big_day_out_lineups WHERE "adelaide" = 'yes' AND "gold_coast" = 'yes' AND "melbourne" = 'yes' AND "auckland" = 'yes'

Question: What is The Melbourne with a No- Gold Coast
SQL: SELECT "melbourne" FROM big_day_out_lineups WHERE "gold_coast" = 'no'