B.P. of 0, and a Pts Agst smaller than 247 has how many total number of played?
CREATE TABLE "national_league_one_table" (
  "position" real,
  "club" text,
  "played" real,
  "drawn" real,
  "lost" real,
  "pts_for" real,
  "pts_agst" real,
  "b_p" real,
  "points" real
);
SELECT COUNT("played") FROM "national_league_one_table" WHERE "b_p"=0 AND "pts_agst"<247;