WHAT ARE THE BYES WITH A DRAWS OF 1, SMW ROVERS, AND WINS LARGER THAN 6?
CREATE TABLE table_name_76 (byes INTEGER, wins VARCHAR, draws VARCHAR, mininera_dfl VARCHAR)
SELECT AVG(byes) FROM table_name_76 WHERE draws = 1 AND mininera_dfl = "smw rovers" AND wins > 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (byes INTEGER, wins VARCHAR, draws VARCHAR, mininera_dfl VARCHAR) Question: WHAT ARE THE BYES WITH A DRAWS OF 1, SMW ROVERS, AND WINS LARGER THAN 6? [/INST] SELECT AVG(byes) FROM table_name_76 WHERE draws = 1 AND mininera_dfl = "smw rovers" AND wins > 6 </s>