Table: fibt_2008_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average number of Gold when the total is 11 with more than 2 silver?
SQL: SELECT AVG("gold") FROM fibt_2008_medals WHERE "total" = 11 AND "silver" > 2

Question: What is the total rank with more than 0 silver and less than 2 medals total?
SQL: SELECT COUNT("rank") FROM fibt_2008_medals WHERE "total" < 2 AND "silver" > 0

Question: What is the value of bronze with less than 2 in total?
SQL: SELECT "bronze" FROM fibt_2008_medals WHERE "total" < 2

Question: What number of rank has more than 2 medals in total with less than 4 bronze?
SQL: SELECT COUNT("rank") FROM fibt_2008_medals WHERE "total" > 2 AND "bronze" < 4