user: ### NOW ANSWER:
Question: What average election in 2003 had an election greater then 6 in 1999 and less then 7 in 2007?
Columns: ['Party', '1999 Election', '2003 Election', '2007 Election', 'May 2010', '2011 Election', 'May 2012']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Conservative', 25.0, 16.0, 41.0, 37.0, 45.0, 46.0]
SQL:

assistant: SELECT AVG("2003 Election") FROM "Table" WHERE "1999 Election" > 6.0 AND "2007 Election" < 7.0;