Which Goals have a Player of noel carroll?
CREATE TABLE "1950s" (
  "debut_year" real,
  "player" text,
  "games" real,
  "goals" real,
  "years_at_club" text
);
SELECT MIN("goals") FROM "1950s" WHERE "player"='noel carroll';