Tell me the total number of gold for bronze more than 0 and total more than 100
CREATE TABLE table_name_2 (
    gold VARCHAR,
    bronze VARCHAR,
    rank VARCHAR
)
SELECT COUNT(gold) FROM table_name_2 WHERE bronze > 0 AND rank = "total" AND "total" > 100
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: Tell me the total number of gold for bronze more than 0 and total more than 100 ### Input: CREATE TABLE table_name_2 (
    gold VARCHAR,
    bronze VARCHAR,
    rank VARCHAR
) ### Response: SELECT COUNT(gold) FROM table_name_2 WHERE bronze > 0 AND rank = "total" AND "total" > 100