user: Question: How many goals were there in game 47?
Columns: ['Name', 'Season', 'Games', 'Goals', 'Assists', 'Points']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Name', 'Season', 'Games', 'Goals', 'Assists', 'Points']
SQL:

assistant: SELECT SUM("Goals") FROM "Table" WHERE "Games" = '47';