Table: agri_production
Columns: production_year
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011

Question: What is the average 2006 value for wheat with a 2005 value greater than 7340?
SQL: SELECT AVG("2006") FROM agri_production WHERE "production_year" = 'wheat' AND "2005" > 7340

Question: What is the average 2002 value for Sunflower, which had a 2010 value less than 5587 and a 2007 value greater than 546?
SQL: SELECT AVG("2002") FROM agri_production WHERE "2010" < 5587 AND "production_year" = 'sunflower' AND "2007" > 546

Question: What is the average 2001 value with a 2010 value greater than 414, a 2011 value of 7192, and a 2005 value larger than 7340?
SQL: SELECT AVG("2001") FROM agri_production WHERE "2010" > 414 AND "2011" = 7192 AND "2005" > 7340

Question: What is the 2006 value with a 2011 value greater than 4113 and a 2008 value less than 7181?
SQL: SELECT SUM("2006") FROM agri_production WHERE "2011" > 4113 AND "2008" < 7181