What was the average number of silver medals won by France when they are ranked higher than 8?
CREATE TABLE table_name_88 (silver INTEGER, nation VARCHAR, rank VARCHAR)
SELECT AVG(silver) FROM table_name_88 WHERE nation = "france" AND rank > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_88 (silver INTEGER, nation VARCHAR, rank VARCHAR) Question: What was the average number of silver medals won by France when they are ranked higher than 8? [/INST] SELECT AVG(silver) FROM table_name_88 WHERE nation = "france" AND rank > 8 </s>