What is the total when gold is 1, and rank is more than 4, and bronze is 0?
CREATE TABLE table_name_1 (
    total VARCHAR,
    bronze VARCHAR,
    gold VARCHAR,
    rank VARCHAR
)
SELECT COUNT(total) FROM table_name_1 WHERE gold = 1 AND rank > 4 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 when gold is 1, and rank is more than 4, and bronze is 0? ### Input: CREATE TABLE table_name_1 (
    total VARCHAR,
    bronze VARCHAR,
    gold VARCHAR,
    rank VARCHAR
) ### Response: SELECT COUNT(total) FROM table_name_1 WHERE gold = 1 AND rank > 4 AND bronze = 0