What is the average Total, when Finish is "T47"?
CREATE TABLE table_name_44 (total INTEGER, finish VARCHAR)
SELECT AVG(total) FROM table_name_44 WHERE finish = "t47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_44 (total INTEGER, finish VARCHAR) Question: What is the average Total, when Finish is "T47"? [/INST] SELECT AVG(total) FROM table_name_44 WHERE finish = "t47" </s>