Table: world_volley_champs
Columns: rank
gold
silver
bronze
total

Question: What is the total for the team with fewer than 2 bronze, ranked less than 4 and fewer than 1 silver?
SQL: SELECT COUNT("total") FROM world_volley_champs WHERE "bronze" < 2 AND "rank" < 4 AND "silver" < 1

Question: How many silver for the team with more than 2 bronze and more than 7 gold?
SQL: SELECT COUNT("silver") FROM world_volley_champs WHERE "bronze" > 2 AND "gold" > 7

Question: What is the total for the team with 0 bronze and 3 silver?
SQL: SELECT SUM("total") FROM world_volley_champs WHERE "bronze" = 0 AND "silver" = 3