CREATE TABLE table_31702 ("Rank" FLOAT, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many bronzes were held by those with a total of 4 and less than 3 silvers.
SELECT SUM("Bronze") FROM table_31702 WHERE "Total" = '4' AND "Silver" < '3'
SELECT SUM("Bronze") FROM "table_31702" WHERE "Silver" < '3' AND "Total" = '4'