what is the maximum total region with fitzroy being 8047
CREATE TABLE table_12570207_1 (total_region INTEGER, fitzroy VARCHAR)
SELECT MAX(total_region) FROM table_12570207_1 WHERE fitzroy = 8047
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_12570207_1 (total_region INTEGER, fitzroy VARCHAR) Question: what is the maximum total region with fitzroy being 8047 [/INST] SELECT MAX(total_region) FROM table_12570207_1 WHERE fitzroy = 8047 </s>