What is the total number of ladies ranked who had less than 3 silvers, less than 2 total medals, and more than 0 bronze medals?
CREATE TABLE table_name_9 (
    rank VARCHAR,
    bronze VARCHAR,
    silver VARCHAR,
    total VARCHAR
)
SELECT COUNT(rank) FROM table_name_9 WHERE silver < 3 AND total < 2 AND bronze > 0
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 is the total number of ladies ranked who had less than 3 silvers, less than 2 total medals, and more than 0 bronze medals? ### Input: CREATE TABLE table_name_9 (
    rank VARCHAR,
    bronze VARCHAR,
    silver VARCHAR,
    total VARCHAR
) ### Response: SELECT COUNT(rank) FROM table_name_9 WHERE silver < 3 AND total < 2 AND bronze > 0