CREATE TABLE table_name_90 (melbourne VARCHAR2, adelaide VARCHAR2, gold_coast VARCHAR2)

yes or no for the melbourne that has no for adelaide, no for gold coast?
SELECT melbourne FROM table_name_90 WHERE adelaide = "yes" AND gold_coast = "no"
SELECT "melbourne" FROM "table_name_90" WHERE "adelaide" = "yes" AND "gold_coast" = "no"