SELECT adelaide FROM table_name_20 WHERE melbourne = "yes" AND auckland = "no" AND perth = "yes"
Melbourne dan Perth dari Adelaide mana yang ya ketika Auckland tidak?
CREATE TABLE table_name_20 (adelaide VARCHAR, perth VARCHAR, melbourne VARCHAR, auckland VARCHAR)