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

yes or no for the auckland with a yes for sydney, no for perth, yes for melbourne and yes for the gold coast?
SELECT "Auckland" FROM table_67833 WHERE "Sydney" = 'yes' AND "Perth" = 'no' AND "Melbourne" = 'yes' AND "Gold Coast" = 'yes'
SELECT "Auckland" FROM "table_67833" WHERE "Gold Coast" = 'yes' AND "Melbourne" = 'yes' AND "Perth" = 'no' AND "Sydney" = 'yes'