Which Byes have Losses larger than 0, and an Against larger than 3049?
CREATE TABLE table_name_7 (byes INTEGER, losses VARCHAR, against VARCHAR)
SELECT AVG(byes) FROM table_name_7 WHERE losses > 0 AND against > 3049
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (byes INTEGER, losses VARCHAR, against VARCHAR) Question: Which Byes have Losses larger than 0, and an Against larger than 3049? [/INST] SELECT AVG(byes) FROM table_name_7 WHERE losses > 0 AND against > 3049 </s>