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

Name the gold coast which has an auckland of no and melbourne of yes
SELECT "Gold Coast" FROM table_67951 WHERE "Auckland" = 'no' AND "Melbourne" = 'yes'
SELECT "Gold Coast" FROM "table_67951" WHERE "Auckland" = 'no' AND "Melbourne" = 'yes'