SELECT gold_coast FROM table_name_49 WHERE perth = "no" AND sydney = "yes" AND auckland = "yes"
Gold Coast mana yang memiliki Perth of No, Sydney ya, dan Auckland ya?
CREATE TABLE table_name_49 (gold_coast VARCHAR, auckland VARCHAR, perth VARCHAR, sydney VARCHAR)