Table: world_tour_2007_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What is the rank with a higher than 2 total, 21 gold and more than 12 bronze?
SQL: SELECT AVG("rank") FROM world_tour_2007_medals WHERE "total" > 2 AND "gold" = 21 AND "bronze" > 12

Question: How many golds does Germany have with more than 1 silver?
SQL: SELECT SUM("gold") FROM world_tour_2007_medals WHERE "silver" > 1 AND "nation" = 'germany'