What was the rating in Brisbane the week it was 276000 in Melbourne? 
CREATE TABLE table_24291077_8 (brisbane INTEGER, melbourne VARCHAR)
SELECT MAX(brisbane) FROM table_24291077_8 WHERE melbourne = 276000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24291077_8 (brisbane INTEGER, melbourne VARCHAR) Question: What was the rating in Brisbane the week it was 276000 in Melbourne?  [/INST] SELECT MAX(brisbane) FROM table_24291077_8 WHERE melbourne = 276000 </s>