What is the average number of casualties for the convoy with a number of U-844?
CREATE TABLE table_name_5 (casualties INTEGER, number VARCHAR)
SELECT AVG(casualties) FROM table_name_5 WHERE number = "u-844"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_5 (casualties INTEGER, number VARCHAR) Question: What is the average number of casualties for the convoy with a number of U-844? [/INST] SELECT AVG(casualties) FROM table_name_5 WHERE number = "u-844" </s>