I want the total number of ties for win % more than 0 and tenure of 2001-2011 with lost more than 16
CREATE TABLE table_name_3 (
    ties VARCHAR,
    lost VARCHAR,
    win__percentage VARCHAR,
    tenure VARCHAR
)
SELECT COUNT(ties) FROM table_name_3 WHERE win__percentage > 0 AND tenure = "2001-2011" AND lost > 16
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: I want the total number of ties for win % more than 0 and tenure of 2001-2011 with lost more than 16 ### Input: CREATE TABLE table_name_3 (
    ties VARCHAR,
    lost VARCHAR,
    win__percentage VARCHAR,
    tenure VARCHAR
) ### Response: SELECT COUNT(ties) FROM table_name_3 WHERE win__percentage > 0 AND tenure = "2001-2011" AND lost > 16