What is the sum of Total when rank is 2?
CREATE TABLE table_name_46 (
    total INTEGER,
    rank VARCHAR
)
SELECT SUM(total) FROM table_name_46 WHERE rank = "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: What is the sum of Total when rank is 2? ### Input: CREATE TABLE table_name_46 (
    total INTEGER,
    rank VARCHAR
) ### Response: SELECT SUM(total) FROM table_name_46 WHERE rank = "2"