Schema: CREATE TABLE table_name_24 (total INTEGER, silver VARCHAR, bronze VARCHAR, rank VARCHAR)
Question: Name the least total when bronze is less than 2 and rank is more than 2 with silver less than 1
SQL: SELECT MIN(total) FROM table_name_24 WHERE bronze < 2 AND rank > 2 AND silver < 1