Table: banbridge_district_data
Columns: geographic_unit
2006
2007
2008
2009
2010
2011

Question: What is the average 2006 value with a 2010 value of 417.9 and a 2011 value greater than 426.7?
SQL: SELECT AVG("2006") FROM banbridge_district_data WHERE "2010" = 417.9 AND "2011" > 426.7

Question: What is the 2011 total with a 2008 value greater than 346.5, a 2009 value of 392, and a 2010 value bigger than 354.6?
SQL: SELECT COUNT("2011") FROM banbridge_district_data WHERE "2008" > 346.5 AND "2009" = 392 AND "2010" > 354.6

Question: What is the total 2008 value with a 2006 value greater than 322.7, a 353.9 in 2011, and a 2009 less than 392?
SQL: SELECT COUNT("2008") FROM banbridge_district_data WHERE "2006" > 322.7 AND "2011" = 353.9 AND "2009" < 392

Question: What is the highest 2009 value with a 2006 value smaller than 280.4, a 2007 less than 2.2, and a 2011 less than 3.5?
SQL: SELECT MAX("2009") FROM banbridge_district_data WHERE "2006" < 280.4 AND "2007" < 2.2 AND "2010" < 3.5

Question: What is the average 2007 value with a 2009 value greater than 2.8, a 4.9 in 2010, and a 2006 less than 2.5?
SQL: SELECT AVG("2007") FROM banbridge_district_data WHERE "2009" > 2.8 AND "2010" = 4.9 AND "2006" < 2.5

Question: What is the 2006 total with a 2010 value greater than 417.9?
SQL: SELECT COUNT("2006") FROM banbridge_district_data WHERE "2010" > 417.9