user: ### NOW ANSWER:
Question: How many 2011 1H values have a 2006 of 27.4 and 2007 over 27.7?
Columns: ['TV Station (Operator)', '2005', '2006', '2007', '2008', '2009', '2010', '2011 1H']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['BBTV CH7', 28.0, 27.4, 27.7, 31.0, 28.0, 31.0, 31.7]
SQL:

assistant: SELECT COUNT("2011 1H") FROM "Table" WHERE "2006" = 27.4 AND "2007" > 27.7;