Table: big_day_out_lineups_3
Columns: auckland
gold_coast
sydney
melbourne
adelaide
perth

Question: What Gold Coast has Auckland cancelled, and Adelaide yes?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_3 WHERE "auckland" = 'cancelled' AND "adelaide" = 'yes'

Question: Which Sydney has Auckland cancelled and Perth yes?
SQL: SELECT "sydney" FROM big_day_out_lineups_3 WHERE "auckland" = 'cancelled' AND "perth" = 'yes'

Question: Which Sydney has Gold Coast no, Adelaide no< and Auckland no?
SQL: SELECT "sydney" FROM big_day_out_lineups_3 WHERE "gold_coast" = 'no' AND "adelaide" = 'no' AND "auckland" = 'no'

Question: Which Gold Coast has Melbourne yes, and Auckland yes?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_3 WHERE "melbourne" = 'yes' AND "auckland" = 'yes'

Question: Which Perth has Auckland yes and Gold Coast yes?
SQL: SELECT "perth" FROM big_day_out_lineups_3 WHERE "auckland" = 'yes' AND "gold_coast" = 'yes'

Question: Which Gold Coast has Auckland no, Adelaide yes, and Melbourne no?
SQL: SELECT "gold_coast" FROM big_day_out_lineups_3 WHERE "auckland" = 'no' AND "adelaide" = 'yes' AND "melbourne" = 'no'