question: Which Adelaide's Melbourne, Sydney, and Gold Coast were all no?
answer: SELECT adelaide FROM table_name_30 WHERE melbourne = "no" AND sydney = "no" AND gold_coast = "no"
context: CREATE TABLE table_name_30 (adelaide VARCHAR, gold_coast VARCHAR, melbourne VARCHAR, sydney VARCHAR)