What is the average number of Byes when there were less than 0 losses and were against 1247?
CREATE TABLE table_name_75 (byes INTEGER, against VARCHAR, draws VARCHAR)
SELECT AVG(byes) FROM table_name_75 WHERE against = 1247 AND draws < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (byes INTEGER, against VARCHAR, draws VARCHAR) Question: What is the average number of Byes when there were less than 0 losses and were against 1247? [/INST] SELECT AVG(byes) FROM table_name_75 WHERE against = 1247 AND draws < 0 </s>