CREATE TABLE table_5250 ("Subject" CLOB, "Grade" FLOAT, "2004" FLOAT, "2005" FLOAT, "2006" FLOAT, "2007" FLOAT, "2008" FLOAT, "2009" FLOAT, "2010" FLOAT)

Which 2007 is the lowest one that has a 2004 of 78, and a 2006 smaller than 80?
SELECT MIN("2007") FROM table_5250 WHERE "2004" = '78' AND "2006" < '80'
SELECT MIN("2007") FROM "table_5250" WHERE "2004" = '78' AND "2006" < '80'