How many games had 41 rushes and were than 197 yards?
CREATE TABLE table_name_21 (games VARCHAR, rushes VARCHAR, yards VARCHAR)
SELECT COUNT(games) FROM table_name_21 WHERE rushes = 41 AND yards < 197
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (games VARCHAR, rushes VARCHAR, yards VARCHAR) Question: How many games had 41 rushes and were than 197 yards? [/INST] SELECT COUNT(games) FROM table_name_21 WHERE rushes = 41 AND yards < 197 </s>