Table: ncaa_swimming_champs
Columns: rank
institution
gold
silver
bronze

Question: What is the highest number of Silvers for rank 7 teams with 1 gold and under 1 bronze?
SQL: SELECT MAX("silver") FROM ncaa_swimming_champs WHERE "bronze" < 1 AND "gold" = 1 AND "rank" = '7'

Question: What is the fewest number of silvers for teams with more than 21 gold and more than 4 bronze?
SQL: SELECT MIN("silver") FROM ncaa_swimming_champs WHERE "bronze" > 4 AND "gold" > 21

Question: What is the average number of silvers for teams ranked 5 with 0 bronze?
SQL: SELECT AVG("silver") FROM ncaa_swimming_champs WHERE "rank" = '5' AND "bronze" < 0