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

What is the result for Gold Coast when Adelaide and Perth are yes, but Auckland is no?
SELECT "Gold Coast" FROM table_71063 WHERE "Adelaide" = 'yes' AND "Auckland" = 'no' AND "Perth" = 'yes'
SELECT "Gold Coast" FROM "table_71063" WHERE "Adelaide" = 'yes' AND "Auckland" = 'no' AND "Perth" = 'yes'