How many carries for the RB averaging 4.7, and a long of over 30 yards?
CREATE TABLE table_name_65 (car INTEGER, avg VARCHAR, long VARCHAR)
SELECT SUM(car) FROM table_name_65 WHERE avg = 4.7 AND long > 30
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_65 (car INTEGER, avg VARCHAR, long VARCHAR) Question: How many carries for the RB averaging 4.7, and a long of over 30 yards? [/INST] SELECT SUM(car) FROM table_name_65 WHERE avg = 4.7 AND long > 30 </s>