CREATE TABLE table_71060 ("Sydney" TEXT, "Melbourne" TEXT, "Perth" TEXT, "Adelaide" TEXT, "Gold Coast" TEXT, "Auckland" TEXT)

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