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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: WHAT ARE THE BYES WITH A DRAWS OF 1, SMW ROVERS, AND WINS LARGER THAN 6? ### Input: CREATE TABLE table_name_76 (
    byes INTEGER,
    wins VARCHAR,
    draws VARCHAR,
    mininera_dfl VARCHAR
) ### Response: SELECT AVG(byes) FROM table_name_76 WHERE draws = 1 AND mininera_dfl = "smw rovers" AND wins > 6