Table: golf_ranking_history
Columns: country
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
1997
1996
1995
1994
1993
1992
1991
1990
1989
1988

Question: What is the average for 2009 when 2001 is more than 0, 1996 is less than 1 and 2004 is more than 2
SQL: SELECT AVG("2009") FROM golf_ranking_history WHERE "2001" > 0 AND "1996" < 1 AND "2004" > 2

Question: What is the listing for 2009 when 1989 is less than 0?
SQL: SELECT SUM("2009") FROM golf_ranking_history WHERE "1989" < 0

Question: what is the average for 2005 when 1995 is more than 3, 1996 is less than 4, and 2011 is more than 5?
SQL: SELECT AVG("2005") FROM golf_ranking_history WHERE "1995" > 3 AND "1996" < 4 AND "2011" > 5

Question: what is the listing for 1999 when 1990 is more than 0, 2003 is 3, 2007 is more than 1 and 1996 is more than 0?
SQL: SELECT SUM("1999") FROM golf_ranking_history WHERE "1990" > 0 AND "2003" = 3 AND "2007" > 1 AND "1996" > 0

Question: what is the listing for 2012 when 2004 is more than 0, 2008 is more than 1 1994 is 8 and 2005 is less than 11?
SQL: SELECT MIN("2012") FROM golf_ranking_history WHERE "2004" > 0 AND "2008" > 1 AND "1994" = 8 AND "2005" < 11

Question: what is the listing for 1992 when 1999 is more than 1, 2008 is less than 2 and 2003 is less than 2?
SQL: SELECT SUM("1992") FROM golf_ranking_history WHERE "1999" > 1 AND "2008" < 2 AND "2003" < 2