Table: pan_american_volleyball
Columns: rank
gold
silver
bronze
total

Question: What is the largest total for a team with fewer than 12 bronze, 1 silver and 0 gold medals?
SQL: SELECT MAX("total") FROM pan_american_volleyball WHERE "bronze" < 12 AND "gold" = 0 AND "silver" = 1

Question: What is the largest total for a team with 1 bronze, 0 gold medals and ranking of 7?
SQL: SELECT MAX("total") FROM pan_american_volleyball WHERE "bronze" = 1 AND "rank" = '7' AND "gold" > 0

Question: What is the number of bronze medals when there are fewer than 0 silver medals?
SQL: SELECT SUM("bronze") FROM pan_american_volleyball WHERE "silver" < 0

Question: What is the highest number of silver medals for a team with total less than 1?
SQL: SELECT MAX("silver") FROM pan_american_volleyball WHERE "total" < 1