Quantas pratas têm 4 como o total com um bronze menor que 2?
CREATE TABLE table_name_42 (silver VARCHAR, total VARCHAR, bronze VARCHAR)
SELECT COUNT(silver) FROM table_name_42 WHERE total = 4 AND bronze < 2