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

Question: What is the Decile with a State Authority and a roll of 120?
SQL: SELECT SUM("decile") FROM alfriston_school WHERE "authority" = 'state' AND "roll" = 120

Question: What is the highest Roll of Orere School with a Decile less than 8 with a State Authority?
SQL: SELECT MAX("roll") FROM alfriston_school WHERE "decile" < 8 AND "authority" = 'state' AND "name" = 'orere school'