Table: francophonie_medals_2
Columns: rank
nation
gold
silver
bronze
total

Question: Name the most rank with bronze of 0 and silver more than 1 and gold more than 0
SQL: SELECT MAX("rank") FROM francophonie_medals_2 WHERE "bronze" = 0 AND "silver" > 1 AND "gold" > 0

Question: Name the average silver with total less than 1
SQL: SELECT AVG("silver") FROM francophonie_medals_2 WHERE "total" < 1