Qual foi o total de Andorra com menos de 10 de prata e mais de 5 de 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