Table: jeux_franco_2005
Columns: rank
nation
gold
silver
bronze
total

Question: How many golds have a Total of 11, and a Bronze smaller than 3?
SQL: SELECT SUM("gold") FROM jeux_franco_2005 WHERE "total" = 11 AND "bronze" < 3

Question: How many golds have a Bronze of 0, a Total larger than 1, a Nation of chad, and a Silver larger than 0?
SQL: SELECT SUM("gold") FROM jeux_franco_2005 WHERE "bronze" = 0 AND "total" > 1 AND "nation" = 'chad' AND "silver" > 0

Question: What is the smallest silver with a Gold of 1, and a Nation of lithuania?
SQL: SELECT MIN("silver") FROM jeux_franco_2005 WHERE "gold" = 1 AND "nation" = 'lithuania'

Question: What is the total bronze with a Gold larger than 1, a Rank of 2, and a Silver smaller than 12?
SQL: SELECT COUNT("bronze") FROM jeux_franco_2005 WHERE "gold" > 1 AND "rank" = 2 AND "silver" < 12