How many total draws were there with a less than 8 loss, more than 30 points, and a goal diff larger than 26?
CREATE TABLE "finalised_league_table" (
  "team" text,
  "game" real,
  "draw" real,
  "loss" real,
  "goal_gain" real,
  "goal_loss" real,
  "goal_diff" real,
  "point" real
);
SELECT COUNT("draw") FROM "finalised_league_table" WHERE "loss"<8 AND "point">30 AND "goal_diff">26;