Table: vulcanus_japan
Columns: country
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
total

Question: How many countries in 2009 have fewer than 1 in 1999, more than 0 in 2006 and none in 1997?
SQL: SELECT COUNT("2009") FROM vulcanus_japan WHERE "1999" < 1 AND "2006" > 0 AND "1997" < 0

Question: How much is the highest number in 2006 with fewer than 0 in 2002?
SQL: SELECT MAX("2006") FROM vulcanus_japan WHERE "2002" < 0

Question: How many are there in 2003 that have 0 in 2001, more than 0 in 2009 and fewer than 0 in 1999?
SQL: SELECT SUM("2003") FROM vulcanus_japan WHERE "2001" = 0 AND "2009" > 0 AND "1999" < 0

Question: Which country has more than 0 in 2012 and 2009, 0 in 2008 and more than 0 in 2004?
SQL: SELECT "country" FROM vulcanus_japan WHERE "2012" > 0 AND "2009" > 0 AND "2008" = 0 AND "2004" > 0