What was the greatest number of rushing yards for a runner who had 283 rushes and less than 10 rushing TDs?
CREATE TABLE table_name_16 (rushing_yards INTEGER, rushes VARCHAR, rushing_tds VARCHAR)
SELECT MAX(rushing_yards) FROM table_name_16 WHERE rushes = 283 AND rushing_tds < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_16 (rushing_yards INTEGER, rushes VARCHAR, rushing_tds VARCHAR) Question: What was the greatest number of rushing yards for a runner who had 283 rushes and less than 10 rushing TDs? [/INST] SELECT MAX(rushing_yards) FROM table_name_16 WHERE rushes = 283 AND rushing_tds < 10 </s>