What is the average number of against with less than 10 losses, more than 0 draws, and more than 7 wins?
CREATE TABLE table_name_74 (against INTEGER, wins VARCHAR, losses VARCHAR, draws VARCHAR)
SELECT AVG(against) FROM table_name_74 WHERE losses < 10 AND draws > 0 AND wins > 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (against INTEGER, wins VARCHAR, losses VARCHAR, draws VARCHAR) Question: What is the average number of against with less than 10 losses, more than 0 draws, and more than 7 wins? [/INST] SELECT AVG(against) FROM table_name_74 WHERE losses < 10 AND draws > 0 AND wins > 7 </s>