CREATE TABLE table_67953 ("Sydney" CLOB, "Melbourne" CLOB, "Perth" CLOB, "Adelaide" CLOB, "Gold Coast" CLOB, "Auckland" CLOB)

Name the Adelaide for Sydney of yes and Perth of yes
SELECT "Adelaide" FROM table_67953 WHERE "Sydney" = 'yes' AND "Perth" = 'yes'
SELECT "Adelaide" FROM "table_67953" WHERE "Perth" = 'yes' AND "Sydney" = 'yes'