what is the weeks on chart for the single from france?
CREATE TABLE table_79842 (
    "Title" text,
    "Album" text,
    "Country" text,
    "Peak position" real,
    "Weeks on chart" real
)
SELECT "Weeks on chart" FROM table_79842 WHERE "Country" = 'france'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the weeks on chart for the single from france? ### Input: CREATE TABLE table_79842 (
    "Title" text,
    "Album" text,
    "Country" text,
    "Peak position" real,
    "Weeks on chart" real
) ### Response: SELECT "Weeks on chart" FROM table_79842 WHERE "Country" = 'france'