What is the lowest number of goals scored by a player in the normal league games where more than 8 total goals were scored?
CREATE TABLE "goalscorers" (
  "name" text,
  "league" real,
  "fa_cup" real,
  "league_cup" real,
  "total" real
);
SELECT MIN("league") FROM "goalscorers" WHERE "total">8;