Table: uk_tv_viewership
Columns: 2006
2007
2008
2009
2010

Question: How many 2010s have a 2007 greater than 4.6, and 8.2 as a 2006?
SQL: SELECT COUNT("2010") FROM uk_tv_viewership WHERE "2007" > 4.6 AND "2006" = 8.2

Question: What 2010 has a 2006 less than 6.9, a 2008 greater than 1.6, and 2 for 2007?
SQL: SELECT "2010" FROM uk_tv_viewership WHERE "2006" < 6.9 AND "2008" > 1.6 AND "2007" = 2

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

Question: What is the highest 2010 that has a 2009 less than 6.5, 0.4 as the 2008, with a 2007 less than 0.5?
SQL: SELECT MAX("2010") FROM uk_tv_viewership WHERE "2009" < 6.5 AND "2008" = 0.4 AND "2007" < 0.5

Question: How many 2007s have 0.2 as a 2006, with a 2010 less than 0.1?
SQL: SELECT SUM("2007") FROM uk_tv_viewership WHERE "2006" = 0.2 AND "2010" < 0.1