How many apps have 28 goals, and a Total smaller than 191?
CREATE TABLE "list_of_players" (
  "nationality" text,
  "position" text,
  "bolton_wanderers_career" text,
  "apps" real,
  "total" real,
  "goals" text
);
SELECT SUM("apps") FROM "list_of_players" WHERE "goals"='28' AND "total"<191;