Which First title has Wins smaller than 8 and in Canada?
CREATE TABLE "champions_by_nationality" (
  "rank" text,
  "country" text,
  "wins" real,
  "winners" real,
  "first_title" real,
  "last_title" real
);
SELECT COUNT("first_title") FROM "champions_by_nationality" WHERE "wins"<8 AND "country"='canada';