CREATE TABLE table_name_30 (adelaide VARCHAR, gold_coast VARCHAR, melbourne VARCHAR, sydney VARCHAR)

Which Adelaide's Melbourne, Sydney, and Gold Coast were all no?
SELECT adelaide FROM table_name_30 WHERE melbourne = "no" AND sydney = "no" AND gold_coast = "no"
SELECT "adelaide" FROM "table_name_30" WHERE "gold_coast" = "no" AND "melbourne" = "no" AND "no" = "sydney"