CREATE TABLE table_name_97 (adelaide VARCHAR, gold_coast VARCHAR, auckland VARCHAR, melbourne VARCHAR)

yes or no for the adelaide with no for auckland, yes for melbourne, yes for the gold coast?
SELECT adelaide FROM table_name_97 WHERE auckland = "no" AND melbourne = "yes" AND gold_coast = "yes"
SELECT "adelaide" FROM "table_name_97" WHERE "auckland" = "no" AND "gold_coast" = "yes" AND "melbourne" = "yes"