Table: swimming_2007_africa_games
Columns: rank
nation
gold
silver
bronze
total

Question: What is the largest total with a Silver of 1, and a Rank larger than 7?
SQL: SELECT MAX("total") FROM swimming_2007_africa_games WHERE "silver" = 1 AND "rank" > 7

Question: How many totals have a Bronze smaller than 3, a Nation of zimbabwe, and a Silver smaller than 6?
SQL: SELECT COUNT("total") FROM swimming_2007_africa_games WHERE "bronze" < 3 AND "nation" = 'zimbabwe' AND "silver" < 6

Question: What is the smallest silver with a Bronze smaller than 6, a Total of 3, and a Rank smaller than 9?
SQL: SELECT MIN("silver") FROM swimming_2007_africa_games WHERE "bronze" < 6 AND "total" = 3 AND "rank" < 9

Question: How many ranks have 0 golds, a Nation of namibia, and a Total smaller than 1?
SQL: SELECT COUNT("rank") FROM swimming_2007_africa_games WHERE "gold" = 0 AND "nation" = 'namibia' AND "total" < 1

Question: How many totals have a Bronze of 0, and a Gold smaller than 0?
SQL: SELECT SUM("total") FROM swimming_2007_africa_games WHERE "bronze" = 0 AND "gold" < 0

Question: What is the total silver with a Rank larger than 9, and a Total larger than 1?
SQL: SELECT SUM("silver") FROM swimming_2007_africa_games WHERE "rank" > 9 AND "total" > 1