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

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'