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

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