Table: world_judo_champs_1983
Columns: rank
nation
gold
silver
bronze
total

Question: What is the lowest silver that has a bronze greater than 1, a gold less than 2, and a total less than 2?
SQL: SELECT MIN("silver") FROM world_judo_champs_1983 WHERE "bronze" > 1 AND "gold" < 2 AND "total" < 2

Question: What average rank that has a silver less than 0?
SQL: SELECT AVG("rank") FROM world_judo_champs_1983 WHERE "silver" < 0

Question: How many silver have 4 as the total with a bronze less than 2?
SQL: SELECT COUNT("silver") FROM world_judo_champs_1983 WHERE "total" = 4 AND "bronze" < 2

Question: How many totals have a rank greater than 4, czech Republic as the nation, and a bronze greater than 0?
SQL: SELECT SUM("total") FROM world_judo_champs_1983 WHERE "rank" > 4 AND "nation" = 'czech republic' AND "bronze" > 0

Question: What average total has a gold greater than 0, and a silver greater than 0, with a bronze greater than 2?
SQL: SELECT AVG("total") FROM world_judo_champs_1983 WHERE "gold" > 0 AND "silver" > 0 AND "bronze" > 2