Table: badminton_1992_olympics_medals
Columns: rank
nation
gold
silver
bronze
total

Question: How many medals were won total for the country that won 1 silver and was ranked 2 or lower?
SQL: SELECT COUNT("total") FROM badminton_1992_olympics_medals WHERE "silver" = 1 AND "rank" < 2

Question: How many silvers did the country with more than 0 gold and a rank above 1 win that had a total less than 4?
SQL: SELECT COUNT("silver") FROM badminton_1992_olympics_medals WHERE "gold" > 0 AND "rank" > 1 AND "total" < 4

Question: How many bronzes were won by the country with a total higher than 5?
SQL: SELECT SUM("bronze") FROM badminton_1992_olympics_medals WHERE "total" > 5

Question: How many bronzes were won for the country that had a larger than 3 rank and a silver win count above 0?
SQL: SELECT SUM("bronze") FROM badminton_1992_olympics_medals WHERE "rank" > 3 AND "silver" > 0