Table: kaitieke_school
Columns: name
years
area
authority
decile
roll

Question: What years does Kakahi school, with a decile of 3, have?
SQL: SELECT "years" FROM kaitieke_school WHERE "decile" = 3 AND "name" = 'kakahi school'

Question: What is the average decile of Ruapehu college, which has a state authority?
SQL: SELECT AVG("decile") FROM kaitieke_school WHERE "authority" = 'state' AND "name" = 'ruapehu college'

Question: What is the roll number of Orautoha school in Raetihi, which has a decile smaller than 8?
SQL: SELECT SUM("roll") FROM kaitieke_school WHERE "area" = 'raetihi' AND "name" = 'orautoha school' AND "decile" < 8