How many 2008s have 6.9 as a 2006, with a 2007 less than 7.1?
CREATE TABLE "table_showing_viewing_share_of_individua" (
  "2006" real,
  "2007" real,
  "2008" real,
  "2009" real,
  "2010" real
);
SELECT COUNT("2008") FROM "table_showing_viewing_share_of_individua" WHERE "2006"=6.9 AND "2007"<7.1;