CREATE TABLE table_name_38 (melbourne VARCHAR(255), sydney VARCHAR(255), auckland VARCHAR(255), perth VARCHAR(255), adelaide VARCHAR(255))
Name the melbourne with perth, adelaide and auckland of no with sydney of yes
    
SQL: SELECT melbourne FROM table_name_38 WHERE perth = "no" AND adelaide = "no" AND auckland = "no" AND sydney = "yes"