Table: big_day_out_lineups_6
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: What is the result for Gold Coast when Melbourne and Adelaide are yes, but Perth is no?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_6 WHERE "melbourne" = 'yes' AND "perth" = 'no' AND "adelaide" = 'yes'

Question: What is the result for Melbourne when Adelaide, Sydney, and Perth are yes, and Gold Coast is no?
SQL: SELECT "melbourne" FROM big_day_out_lineups_6 WHERE "adelaide" = 'yes' AND "sydney" = 'yes' AND "perth" = 'yes' AND "gold_coast" = 'no'

Question: What is the result for Melbourne when Gold Coast, Perth, Auckland, and Sydney are no?
SQL: SELECT "melbourne" FROM big_day_out_lineups_6 WHERE "gold_coast" = 'no' AND "perth" = 'no' AND "auckland" = 'no' AND "sydney" = 'no'

Question: What is the result for Gold Coast when Adelaide and Perth are yes, but Auckland is no?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_6 WHERE "adelaide" = 'yes' AND "auckland" = 'no' AND "perth" = 'yes'

Question: What is the result for Gold Coast when Melbourne and Sydney are yes, while Auckland and Perth are no?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_6 WHERE "melbourne" = 'yes' AND "sydney" = 'yes' AND "auckland" = 'no' AND "perth" = 'no'

Question: What is the result for Melbourne when Adelaide is no, and Auckland is yes?
SQL: SELECT "melbourne" FROM big_day_out_lineups_6 WHERE "adelaide" = 'no' AND "auckland" = 'yes'