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

Which Sydney has Auckland cancelled and Perth yes?
SELECT "Sydney" FROM table_70887 WHERE "Auckland" = 'cancelled' AND "Perth" = 'yes'
SELECT "Sydney" FROM "table_70887" WHERE "Auckland" = 'cancelled' AND "Perth" = 'yes'