When the regular season of 2nd, Northeast and the year was less than 2008 what was the total number of Division?
CREATE TABLE "year_by_year" (
  "year" real,
  "division" real,
  "league" text,
  "regular_season" text,
  "playoffs" text,
  "open_cup" text
);
SELECT COUNT("division") FROM "year_by_year" WHERE "regular_season"='2nd, northeast' AND "year"<2008;