Table: ahititi_school
Columns: name
years
area
authority
decile
roll

Question: Which school has a decile of 8 and a roll of 705?
SQL: SELECT "name" FROM ahititi_school WHERE "decile" = 8 AND "roll" = 705

Question: What is the roll of the school in Oakura?
SQL: SELECT SUM("roll") FROM ahititi_school WHERE "area" = 'oakura'

Question: What is the avererage decile of Francis Douglas Memorial College?
SQL: SELECT AVG("decile") FROM ahititi_school WHERE "name" = 'francis douglas memorial college'