I want to know the sum of fa cup goals for david mirfin and total goals less than 1
CREATE TABLE "appearances_and_goals" (
  "squad_no" real,
  "name" text,
  "position" text,
  "league_apps" text,
  "league_goals" real,
  "fa_cup_apps" text,
  "fa_cup_goals" real,
  "league_cup_apps" text,
  "league_cup_goals" real,
  "flt_apps" text,
  "flt_goals" real,
  "total_apps" text,
  "total_goals" real
);
SELECT SUM("fa_cup_goals") FROM "appearances_and_goals" WHERE "name"='david mirfin' AND "total_goals"<1;