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

Question: Which area has a Decile of 9, and a Roll of 31?
SQL: SELECT "area" FROM canterbury_schools WHERE "decile" = 9 AND "roll" = 31

Question: How many deciles have Years of 9–13?
SQL: SELECT COUNT("decile") FROM canterbury_schools WHERE "years" = '9–13'

Question: What is the name with a Decile less than 10, and a Roll of 297?
SQL: SELECT "name" FROM canterbury_schools WHERE "decile" < 10 AND "roll" = 297

Question: Which name has a Roll larger than 297, and Years of 7–13?
SQL: SELECT "name" FROM canterbury_schools WHERE "roll" > 297 AND "years" = '7–13'

Question: Which years have a Name of ladbrooks school?
SQL: SELECT "years" FROM canterbury_schools WHERE "name" = 'ladbrooks school'

Question: What is the total of the roll with a Decile of 8, and an Area of hororata?
SQL: SELECT SUM("roll") FROM canterbury_schools WHERE "decile" = 8 AND "area" = 'hororata'