How many losses for the team with less than 4 wins, more than 0 byes and 2510 against?
CREATE TABLE table_name_39 (losses INTEGER, byes VARCHAR, wins VARCHAR, against VARCHAR)
SELECT AVG(losses) FROM table_name_39 WHERE wins < 4 AND against = 2510 AND byes > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_39 (losses INTEGER, byes VARCHAR, wins VARCHAR, against VARCHAR) Question: How many losses for the team with less than 4 wins, more than 0 byes and 2510 against? [/INST] SELECT AVG(losses) FROM table_name_39 WHERE wins < 4 AND against = 2510 AND byes > 0 </s>