user: ### NOW ANSWER:
Question: what is the weeks on chart for the single from France?
Columns: ['Title', 'Album', 'Country', 'Peak position', 'Weeks on chart']
Types: ['text', 'text', 'text', 'real', 'real']
Sample row: ['"Mirage"', 'Best Of', 'Sweden', 2.0, 5.0]
SQL:

assistant: SELECT "Weeks on chart" FROM "Table" WHERE "Country" = 'France';