Table: uci_cyclo_x_world_4
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average bronze when the total is 2, silver is less than 1 and gold is more than 1?
SQL: SELECT AVG("bronze") FROM uci_cyclo_x_world_4 WHERE "total" = 2 AND "silver" < 1 AND "gold" > 1

Question: what is the average silver when the total is more than 20?
SQL: SELECT AVG("silver") FROM uci_cyclo_x_world_4 WHERE "total" > 20

Question: what is the highest rank when the nation is united states (usa) and bronze is more than 1?
SQL: SELECT MAX("rank") FROM uci_cyclo_x_world_4 WHERE "nation" = 'united states (usa)' AND "bronze" > 1

Question: what is the average total when bronze is more than 0, gold is 0, the nation is united states (usa) and silver is 0?
SQL: SELECT AVG("total") FROM uci_cyclo_x_world_4 WHERE "bronze" > 0 AND "gold" = 0 AND "nation" = 'united states (usa)' AND "silver" < 0