CREATE TABLE table_name_6 (adelaide VARCHAR2, sydney VARCHAR2, perth VARCHAR2)

Name the Adelaide for Sydney of yes and Perth of yes
SELECT adelaide FROM table_name_6 WHERE sydney = "yes" AND perth = "yes"
SELECT "adelaide" FROM "table_name_6" WHERE "perth" = "yes" AND "sydney" = "yes"