CREATE TABLE table_61010 ("2006" FLOAT, "2007" FLOAT, "2008" FLOAT, "2009" FLOAT, "2010" FLOAT)

How many 2008s have 6.9 as a 2006, with a 2007 less than 7.1?
SELECT COUNT("2008") FROM table_61010 WHERE "2006" = '6.9' AND "2007" < '7.1'
SELECT COUNT("2008") FROM "table_61010" WHERE "2006" = '6.9' AND "2007" < '7.1'