What was Andorra's total with less than 10 silver and more than 5 bronze?
CREATE TABLE table_name_97 (
    total INTEGER,
    bronze VARCHAR,
    silver VARCHAR,
    nation VARCHAR
)
SELECT SUM(total) FROM table_name_97 WHERE silver < 10 AND nation = "andorra" AND bronze > 5
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 was Andorra's total with less than 10 silver and more than 5 bronze? ### Input: CREATE TABLE table_name_97 (
    total INTEGER,
    bronze VARCHAR,
    silver VARCHAR,
    nation VARCHAR
) ### Response: SELECT SUM(total) FROM table_name_97 WHERE silver < 10 AND nation = "andorra" AND bronze > 5