human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Title, Album, Country, Peak position, Weeks on chart
###Question: what is the weeks on chart for the single from france?
gpt
SELECT Weeks on chart FROM table WHERE Country = france