Table: wwc_1999
Columns: rank
nation
gold
silver
bronze
total

Question: Which country had 1 Bronze, 1 Silver, with a total of 3 medals?
SQL: SELECT "nation" FROM wwc_1999 WHERE "bronze" = 1 AND "total" = 3 AND "silver" = 1

Question: Which country had more than 2 silvers and less than 4 golds?
SQL: SELECT "nation" FROM wwc_1999 WHERE "silver" > 2 AND "gold" < 4

Question: What's the average bronze with a total number of medals being 1, with more than 0 silvers?
SQL: SELECT AVG("bronze") FROM wwc_1999 WHERE "total" = 1 AND "silver" > 0