SELECT auckland FROM table_name_1 WHERE adelaide = "no" AND melbourne = "yes" AND sydney = "yes"
Auckland mana yang memiliki adelaide of no, Melbourne ya, dan Sydney ya?
CREATE TABLE table_name_1 (auckland VARCHAR, sydney VARCHAR, adelaide VARCHAR, melbourne VARCHAR)