Table: big_day_out_lineups_5
Columns: sydney
melbourne
perth
adelaide
gold_coast
auckland

Question: Which Perth's gold coast and Adelaide were yes when Auckland was no?
SQL: SELECT "perth" FROM big_day_out_lineups_5 WHERE "gold_coast" = 'yes' AND "adelaide" = 'yes' AND "auckland" = 'no'

Question: Which Melbourne had a gold coast and sydney which were yes, but an adelaide that was no?
SQL: SELECT "melbourne" FROM big_day_out_lineups_5 WHERE "gold_coast" = 'yes' AND "adelaide" = 'no' AND "sydney" = 'yes'

Question: Which Adelaide's Melbourne and Perth were yes when Auckland was no?
SQL: SELECT "adelaide" FROM big_day_out_lineups_5 WHERE "melbourne" = 'yes' AND "auckland" = 'no' AND "perth" = 'yes'

Question: Which Sydney's Melbourne was no, when Auckland was yes?
SQL: SELECT "sydney" FROM big_day_out_lineups_5 WHERE "melbourne" = 'no' AND "auckland" = 'yes'

Question: Which Syndney's Gold coast, Adelaide, Melbourne, and Auckland were all no?
SQL: SELECT "sydney" FROM big_day_out_lineups_5 WHERE "gold_coast" = 'no' AND "adelaide" = 'no' AND "melbourne" = 'no' AND "auckland" = 'no'

Question: Which Adelaide's Melbourne, Sydney, and Gold Coast were all no?
SQL: SELECT "adelaide" FROM big_day_out_lineups_5 WHERE "melbourne" = 'no' AND "sydney" = 'no' AND "gold_coast" = 'no'