How many draws have less than 35 losses with 136 matches and less than 146 against?
CREATE TABLE table_name_47 (draw INTEGER, against VARCHAR, losses VARCHAR, matches VARCHAR)
SELECT AVG(draw) FROM table_name_47 WHERE losses < 35 AND matches = 136 AND against < 146
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (draw INTEGER, against VARCHAR, losses VARCHAR, matches VARCHAR) Question: How many draws have less than 35 losses with 136 matches and less than 146 against? [/INST] SELECT AVG(draw) FROM table_name_47 WHERE losses < 35 AND matches = 136 AND against < 146 </s>