CREATE TABLE table_name_84 (sydney VARCHAR, gold_coast VARCHAR, perth VARCHAR, adelaide VARCHAR)

Which Sydney has a Perth of no, an Adelaide of yes, and a Gold Coast of no?
SELECT sydney FROM table_name_84 WHERE perth = "no" AND adelaide = "yes" AND gold_coast = "no"
SELECT "sydney" FROM "table_name_84" WHERE "adelaide" = "yes" AND "gold_coast" = "no" AND "no" = "perth"