Table schema:
CREATE TABLE table_name_4 (goals INTEGER, player VARCHAR)

Question: Which Goals have a Player of noel carroll?
SQL: SELECT MIN(goals) FROM table_name_4 WHERE player = "noel carroll"