What was the rating for Brisbane the week that Adelaide had 94000?
CREATE TABLE table_24291077_8 (brisbane INTEGER, adelaide VARCHAR)
SELECT MIN(brisbane) FROM table_24291077_8 WHERE adelaide = 94000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24291077_8 (brisbane INTEGER, adelaide VARCHAR) Question: What was the rating for Brisbane the week that Adelaide had 94000? [/INST] SELECT MIN(brisbane) FROM table_24291077_8 WHERE adelaide = 94000 </s>