user: ### NOW ANSWER:
Question: What is the total number of league goals for simon charlton?
Columns: ['Name', 'Position', 'League Apps', 'League Goals', 'FA Cup Apps', 'FA Cup Goals', 'League Cup Apps', 'League Cup Goals', 'FLT Apps', 'FLT Goals', 'Total Apps', 'Total Goals']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real']
Sample row: ['Junior Bent', 'MF', '6 (1)', 1.0, '0', 0.0, '1', 0.0, '1', 0.0, '8 (1)', 1.0]
SQL:

assistant: SELECT COUNT("League Goals") FROM "Table" WHERE "Name" = 'simon charlton';