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

Which Gold Coast has a Perth of no, a Sydney of yes, and an Auckland of yes?
SELECT "Gold Coast" FROM table_68014 WHERE "Perth" = 'no' AND "Sydney" = 'yes' AND "Auckland" = 'yes'
SELECT "Gold Coast" FROM "table_68014" WHERE "Auckland" = 'yes' AND "Perth" = 'no' AND "Sydney" = 'yes'