Table: junior_vb_champs
Columns: rank
gold
silver
bronze
total

Question: What is the lowest bronze number when silver shows 2, and the total is 8?
SQL: SELECT MIN("bronze") FROM junior_vb_champs WHERE "silver" = 2 AND "total" = 8

Question: What is the silver number when gold is more than 4, and the total is less than 24?
SQL: SELECT AVG("silver") FROM junior_vb_champs WHERE "gold" > 4 AND "total" < 24

Question: What is the gold number when the total is 8 and bronze is more than 4?
SQL: SELECT AVG("gold") FROM junior_vb_champs WHERE "total" = 8 AND "bronze" > 4

Question: What is the sum of Total for 0 gold and less than 2, silver with a rank of 6?
SQL: SELECT SUM("total") FROM junior_vb_champs WHERE "gold" = 0 AND "silver" < 2 AND "rank" = '6'

Question: What is the average Gold when silver is more than 2, and bronze is more than 1
SQL: SELECT AVG("gold") FROM junior_vb_champs WHERE "silver" > 2 AND "bronze" > 1

Question: What is the average Bronze when silver is more than 2, and rank is 2, and gold more than 2
SQL: SELECT AVG("bronze") FROM junior_vb_champs WHERE "silver" > 2 AND "rank" = '2' AND "gold" > 2