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

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