Name the number of apps for total g is 8
CREATE TABLE "squad_stats" (
  "player" text,
  "nat" text,
  "pos" text,
  "l_apps" real,
  "l_g" real,
  "c_apps" real,
  "total_apps" real,
  "total_g" real
);
SELECT COUNT("l_apps") FROM "squad_stats" WHERE "total_g"=8;