user: ### NOW ANSWER:
Question: How many weeks was France at #1?
Columns: ['Artist', 'Country', 'Number-one single(s)', 'Year', 'Weeks at #1', 'Straight to #1 ?']
Types: ['text', 'text', 'text', 'real', 'real', 'text']
Sample row: ['Kamini', 'France', '" Marly-Gomont "', 2007.0, 4.0, 'No']
SQL:

assistant: SELECT MAX("Weeks at #1") FROM "Table" WHERE "Country" = 'France';