What is the average number of losses for teams with 0 draws and 0 byes?
CREATE TABLE table_name_78 (losses INTEGER, draws VARCHAR, byes VARCHAR)
SELECT AVG(losses) FROM table_name_78 WHERE draws = 0 AND byes < 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (losses INTEGER, draws VARCHAR, byes VARCHAR) Question: What is the average number of losses for teams with 0 draws and 0 byes? [/INST] SELECT AVG(losses) FROM table_name_78 WHERE draws = 0 AND byes < 0 </s>