user: ### NOW ANSWER:
Question: How many total League goals does Player John O'Flynn have?
Columns: ['Player', 'Club', 'League goals', 'Cup goals', 'Total']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['Jason Byrne', 'Shelbourne', 22.0, 8.0, 30.0]
SQL:

assistant: SELECT SUM("League goals") FROM "Table" WHERE "Player" = 'John O''Flynn';