What is the total number played with 1 drawn, and less than 7 points?
CREATE TABLE "promotion_round" (
  "position" real,
  "name" text,
  "played" real,
  "drawn" real,
  "lost" real,
  "points" real
);
SELECT COUNT("played") FROM "promotion_round" WHERE "drawn"=1 AND "points"<7;