How many carries have an average under 8.7 and touchdowns of 72?
CREATE TABLE table_name_37 (carries VARCHAR, average VARCHAR, touchdowns VARCHAR)
SELECT COUNT(carries) FROM table_name_37 WHERE average < 8.7 AND touchdowns = 72
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (carries VARCHAR, average VARCHAR, touchdowns VARCHAR) Question: How many carries have an average under 8.7 and touchdowns of 72? [/INST] SELECT COUNT(carries) FROM table_name_37 WHERE average < 8.7 AND touchdowns = 72 </s>