What was the highest number of yards in years where there were fewer than 51 rushes and more than 12 games?
CREATE TABLE table_name_48 (yards INTEGER, rushes VARCHAR, games VARCHAR)
SELECT MAX(yards) FROM table_name_48 WHERE rushes < 51 AND games > 12
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (yards INTEGER, rushes VARCHAR, games VARCHAR) Question: What was the highest number of yards in years where there were fewer than 51 rushes and more than 12 games? [/INST] SELECT MAX(yards) FROM table_name_48 WHERE rushes < 51 AND games > 12 </s>