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

Question: What is the average decile for te puru school?
SQL: SELECT AVG("decile") FROM colville_school WHERE "name" = 'te puru school'

Question: What is the total decile with an Area of whitianga, and a Roll smaller than 835?
SQL: SELECT SUM("decile") FROM colville_school WHERE "area" = 'whitianga' AND "roll" < 835

Question: Which name has an Area of kennedy bay?
SQL: SELECT "name" FROM colville_school WHERE "area" = 'kennedy bay'

Question: Which years have a Decile larger than 4, and an Area of thames?
SQL: SELECT "years" FROM colville_school WHERE "decile" > 4 AND "area" = 'thames'

Question: Which Authority has a Decile smaller than 6, and an Area of opoutere?
SQL: SELECT "authority" FROM colville_school WHERE "decile" < 6 AND "area" = 'opoutere'

Question: Which gender has Years of 1–8, an Authority of state, a Roll less than 184, and a Name of matatoki school?
SQL: SELECT "gender" FROM colville_school WHERE "years" = '1–8' AND "authority" = 'state' AND "roll" < 184 AND "name" = 'matatoki school'