Name the number of silver when gold is less than 1 and bronze is 0 when total is less than 2
CREATE TABLE table_name_18 (
    silver VARCHAR,
    total VARCHAR,
    gold VARCHAR,
    bronze VARCHAR
)
SELECT COUNT(silver) FROM table_name_18 WHERE gold < 1 AND bronze = 0 AND total < 2
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: Name the number of silver when gold is less than 1 and bronze is 0 when total is less than 2 ### Input: CREATE TABLE table_name_18 (
    silver VARCHAR,
    total VARCHAR,
    gold VARCHAR,
    bronze VARCHAR
) ### Response: SELECT COUNT(silver) FROM table_name_18 WHERE gold < 1 AND bronze = 0 AND total < 2