CREATE TABLE table_name_20 (adelaide VARCHAR, perth VARCHAR, melbourne VARCHAR, auckland VARCHAR)

Which Adelaide's Melbourne and Perth were yes when Auckland was no?
SELECT adelaide FROM table_name_20 WHERE melbourne = "yes" AND auckland = "no" AND perth = "yes"
SELECT "adelaide" FROM "table_name_20" WHERE "auckland" = "no" AND "melbourne" = "yes" AND "perth" = "yes"