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

Which Adelaide has Perth no, Gold Coast no, and Sydney yes?
SELECT "Adelaide" FROM table_70984 WHERE "Perth" = 'no' AND "Gold Coast" = 'yes' AND "Sydney" = 'yes'
SELECT "Adelaide" FROM "table_70984" WHERE "Gold Coast" = 'yes' AND "Perth" = 'no' AND "Sydney" = 'yes'