user: ### NOW ANSWER:
Question: How many goals did a player from France have?
Columns: ['Player', 'Country', 'Caps', 'Goals', 'Years Active']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Jacob Burns', 'Australia', 11.0, '(0)', '2000-']
SQL:

assistant: SELECT "Goals" FROM "Table" WHERE "Country" = 'France';