user: ### NOW ANSWER:
Question: How many countries in 2009 have fewer than 1 in 1999, more than 0 in 2006 and none in 1997?
Columns: ['Country', '1997', '1998', '1999', '2000', '2001', '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009', '2010', '2011', '2012', 'Total']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Austria', 0.0, 0.0, 0.0, 1.0, 1.0, 1.0, 0.0, 0.0, 0.0, 1.0, 2.0, 0.0, 1.0, 0.0, 0.0, 0.0, 7.0]
SQL:

assistant: SELECT COUNT("2009") FROM "Table" WHERE "1999" < 1.0 AND "2006" > 0.0 AND "1997" < 0.0;