CREATE TABLE table_name_52 (melbourne VARCHAR2, gold_coast VARCHAR2, perth VARCHAR2, adelaide VARCHAR2, sydney VARCHAR2)

What is the result for Melbourne when Adelaide, Sydney, and Perth are yes, and Gold Coast is no?
SELECT melbourne FROM table_name_52 WHERE adelaide = "yes" AND sydney = "yes" AND perth = "yes" AND gold_coast = "no"
SELECT "melbourne" FROM "table_name_52" WHERE "adelaide" = "yes" AND "gold_coast" = "no" AND "perth" = "yes" AND "sydney" = "yes"