CREATE TABLE table_name_27 (sydney VARCHAR(255), gold_coast VARCHAR(255), perth VARCHAR(255), melbourne VARCHAR(255))
Which Sydney has a Perth of no, a Melbourne of yes, and a Gold Coast of no?
    
SQL: SELECT sydney FROM table_name_27 WHERE perth = "no" AND melbourne = "yes" AND gold_coast = "no"