Table: baseball_world_cup_stats
Columns: rank
country
gold
silver
bronze
total

Question: What was the sum of the ranks for Japan who had less than 5 bronze medals and more than 3 silvers?
SQL: SELECT SUM("rank") FROM baseball_world_cup_stats WHERE "bronze" < 5 AND "country" = 'japan' AND "silver" > 3

Question: What is the lowest total medals for the united states who had more than 11 silver medals?
SQL: SELECT MIN("total") FROM baseball_world_cup_stats WHERE "country" = 'united states' AND "silver" > 11

Question: What is the sum of the bronze medals when there were more than 2 silver medals and a rank larger than 6?
SQL: SELECT SUM("bronze") FROM baseball_world_cup_stats WHERE "silver" > 2 AND "rank" > 6