Table: boxwood_school_scores
Columns: subject
grade
2004
2005
2006
2007
2008
2009
2010

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

Question: Which 2005 is the lowest one that has a Grade smaller than 6, and a 2008 smaller than 80, and a 2006 larger than 72?
SQL: SELECT MIN("2005") FROM boxwood_school_scores WHERE "grade" < 6 AND "2008" < 80 AND "2006" > 72