Table: rifle_50m_three_positions
Columns: rank
gold
silver
bronze
total

Question: what is the highest silver when the total is 4 and bronze is less than 1?
SQL: SELECT MAX("silver") FROM rifle_50m_three_positions WHERE "total" = '4' AND "bronze" < 1

Question: what is the gold when the bronze is 1, total is 6 and silver is less than 3?
SQL: SELECT SUM("gold") FROM rifle_50m_three_positions WHERE "bronze" = 1 AND "total" = '6' AND "silver" < 3