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