user: Question: Which Goals have a Player of Noel Carroll?
Columns: ['Debut year', 'Player', 'Games', 'Goals', 'Years at club']
Types: ['real', 'text', 'real', 'real', 'text']
Sample row: [1950.0, 'Alan Sorrell', 1.0, 0.0, '1950']
SQL:

assistant: SELECT "Goals" FROM "Table" WHERE "Player" = 'Noel Carroll';