Table: goalball_2000_summer_paralympics
Columns: rank
nation
gold
silver
bronze
total

Question: How many bronze medals were won when the total is more than 1, and gold is more than 0?
SQL: SELECT AVG("bronze") FROM goalball_2000_summer_paralympics WHERE "total" > 1 AND "gold" > 0

Question: What is the rank when there was less than 1 gold, 0 bronze, and more than 1 total?
SQL: SELECT SUM("rank") FROM goalball_2000_summer_paralympics WHERE "gold" < 1 AND "bronze" = 0 AND "total" > 1

Question: What is the total when there were less than 0 bronze?
SQL: SELECT COUNT("total") FROM goalball_2000_summer_paralympics WHERE "bronze" < 0

Question: What is the rank when there is 0 gold, the total is more than 1, and silver is more than 0?
SQL: SELECT MAX("rank") FROM goalball_2000_summer_paralympics WHERE "gold" = 0 AND "total" > 1 AND "silver" > 0

Question: What is the number of gold medals for Lithuania (ltu), when the total is more than 1?
SQL: SELECT MAX("gold") FROM goalball_2000_summer_paralympics WHERE "nation" = 'lithuania (ltu)' AND "total" > 1