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

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'