Table: fibt_champs_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average rank of Great Britain when their total is over 4?
SQL: SELECT AVG("rank") FROM fibt_champs_medals WHERE "total" > 4 AND "nation" = 'great britain'

Question: What is the total number of Silvers held by France when their rank was over 14?
SQL: SELECT COUNT("silver") FROM fibt_champs_medals WHERE "nation" = 'france' AND "rank" > 14