Schema: CREATE TABLE table_name_92 (weeks_on_chart VARCHAR, country VARCHAR)
Question: what is the weeks on chart for the single from france?
SQL: SELECT weeks_on_chart FROM table_name_92 WHERE country = "france"