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

Which Adelaide has Sydney yes, Melbourne yes, and Perth no?
SELECT "Adelaide" FROM table_70983 WHERE "Sydney" = 'yes' AND "Melbourne" = 'yes' AND "Perth" = 'no'
SELECT "Adelaide" FROM "table_70983" WHERE "Melbourne" = 'yes' AND "Perth" = 'no' AND "Sydney" = 'yes'