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

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