CREATE TABLE table_name_11 (melbourne VARCHAR2, adelaide VARCHAR2, gold_coast VARCHAR2, perth VARCHAR2)

Which Melbourne has Gold Coast yes, Perth cancelled, and Adelaide cancelled?
SELECT melbourne FROM table_name_11 WHERE gold_coast = "yes" AND perth = "cancelled" AND adelaide = "cancelled"
SELECT "melbourne" FROM "table_name_11" WHERE "adelaide" = "cancelled" AND "cancelled" = "perth" AND "gold_coast" = "yes"