Table: big_day_out_lineups_4
Columns: sydney
gold_coast
adelaide
melbourne
perth

Question: Which Perth also has Sydney yes, Gold Coast yes, and Adelaide no?
SQL: SELECT "perth" FROM big_day_out_lineups_4 WHERE "sydney" = 'yes' AND "gold_coast" = 'yes' AND "adelaide" = 'no'

Question: Which Perth has Gold Coast yes, Sydney yes, Melbourne yes, and Adelaide yes?
SQL: SELECT "perth" FROM big_day_out_lineups_4 WHERE "gold_coast" = 'yes' AND "sydney" = 'yes' AND "melbourne" = 'yes' AND "adelaide" = 'yes'

Question: Which Adelaide has Sydney yes, Melbourne yes, and Perth no?
SQL: SELECT "adelaide" FROM big_day_out_lineups_4 WHERE "sydney" = 'yes' AND "melbourne" = 'yes' AND "perth" = 'no'

Question: Which Adelaide has Perth no, Gold Coast no, and Sydney yes?
SQL: SELECT "adelaide" FROM big_day_out_lineups_4 WHERE "perth" = 'no' AND "gold_coast" = 'yes' AND "sydney" = 'yes'

Question: Which Melbourne has Gold Coast yes, Perth cancelled, and Adelaide cancelled?
SQL: SELECT "melbourne" FROM big_day_out_lineups_4 WHERE "gold_coast" = 'yes' AND "perth" = 'cancelled' AND "adelaide" = 'cancelled'

Question: Which Melbourne has Sydney yes, Gold Coast yes, and Perth yes?
SQL: SELECT "melbourne" FROM big_day_out_lineups_4 WHERE "sydney" = 'yes' AND "gold_coast" = 'yes' AND "perth" = 'yes'