What was the average of games that were one in 1978 that were smaller than 141?
CREATE TABLE table_name_42 (wins INTEGER, years VARCHAR, games VARCHAR)
SELECT AVG(wins) FROM table_name_42 WHERE years = "1978" AND games < 141
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (wins INTEGER, years VARCHAR, games VARCHAR) Question: What was the average of games that were one in 1978 that were smaller than 141? [/INST] SELECT AVG(wins) FROM table_name_42 WHERE years = "1978" AND games < 141 </s>