user: ### NOW ANSWER:
Question: What is the highest number of goals scored
Columns: ['Name', 'Position', 'Period', 'Appearances¹', 'Goals¹', 'Nationality²']
Types: ['text', 'text', 'text', 'real', 'real', 'text']
Sample row: ['Jean-Claude Fernandes', 'Defender', '1993 – 1994', 1.0, 0.0, 'France']
SQL:

assistant: SELECT MAX("Goals¹") FROM "Table";