user: ### NOW ANSWER:
Question: Which 2007 is the lowest one that has a 2004 of 78, and a 2006 smaller than 80?
Columns: ['Subject', 'Grade', '2004', '2005', '2006', '2007', '2008', '2009', '2010']
Types: ['text', 'real', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: ['Mathematics', 6.0, 99.0, 75.0, 80.0, 72.0, 77.0, 92.0, 90.0]
SQL:

assistant: SELECT MIN("2007") FROM "Table" WHERE "2004" = 78.0 AND "2006" < 80.0;