Table: thailand_tv_ratings
Columns: tv_station_operator
2005
2006
2007
2008
2009
2010
2011_1h

Question: How many 2011 1H values have a 2006 of 27.4 and 2007 over 27.7?
SQL: SELECT COUNT("2011_1h") FROM thailand_tv_ratings WHERE "2006" = 27.4 AND "2007" > 27.7

Question: What is the highest 2011 1H value for a 2005 over 28?
SQL: SELECT MAX("2011_1h") FROM thailand_tv_ratings WHERE "2005" > 28

Question: What is the number of 2008 values having a 2006 under 17.3, 2010 over 4, and 2011 1H of 20?
SQL: SELECT COUNT("2008") FROM thailand_tv_ratings WHERE "2006" < 17.3 AND "2010" > 4 AND "2011_1h" = 20

Question: What is the average 2007 value for a 2006 of 2.8 and 2009 under 20?
SQL: SELECT AVG("2007") FROM thailand_tv_ratings WHERE "2009" < 20 AND "2006" = 2.8