CREATE TABLE table_name_27 (sydney VARCHAR, gold_coast VARCHAR, perth VARCHAR, melbourne VARCHAR)

Which Sydney has a Perth of no, a Melbourne of yes, and a Gold Coast of no?
SELECT sydney FROM table_name_27 WHERE perth = "no" AND melbourne = "yes" AND gold_coast = "no"
SELECT "sydney" FROM "table_name_27" WHERE "gold_coast" = "no" AND "melbourne" = "yes" AND "no" = "perth"