Table 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"