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

Question: tell me the average roll for the featherston area and integrated authority.
SQL: SELECT AVG("roll") FROM featherston_school WHERE "area" = 'featherston' AND "authority" = 'integrated'

Question: tell me the authority that has a decile less than 6 and roll less than 65.
SQL: SELECT "authority" FROM featherston_school WHERE "decile" < 6 AND "roll" < 65

Question: tell me the average roll for pirinoa school.
SQL: SELECT AVG("roll") FROM featherston_school WHERE "name" = 'pirinoa school'

Question: tell me the total number of decile with a roll showing 251.
SQL: SELECT COUNT("decile") FROM featherston_school WHERE "roll" = 251