Table: conifer_grove_school
Columns: name
years
gender
area
authority
decile
roll

Question: Which authority had a role of 651?
SQL: SELECT "authority" FROM conifer_grove_school WHERE "roll" = 651

Question: For the roll of 651, what was the lowest Decile?
SQL: SELECT MIN("decile") FROM conifer_grove_school WHERE "roll" = 651

Question: What were the years for Redhill school, authority of state?
SQL: SELECT "years" FROM conifer_grove_school WHERE "authority" = 'state' AND "name" = 'redhill school'

Question: What was the sum roll of Karaka area?
SQL: SELECT SUM("roll") FROM conifer_grove_school WHERE "area" = 'karaka'