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

Question: Which area has Years of 1–8, a Decile smaller than 7, and a Name of waikari school?
SQL: SELECT "area" FROM amberley_school WHERE "years" = '1–8' AND "decile" < 7 AND "name" = 'waikari school'

Question: What is the average decile with Years of 1–8, and an Area of waipara?
SQL: SELECT AVG("decile") FROM amberley_school WHERE "years" = '1–8' AND "area" = 'waipara'

Question: Which area has Years of 1–8, and a Name of broomfield school?
SQL: SELECT "area" FROM amberley_school WHERE "years" = '1–8' AND "name" = 'broomfield school'

Question: What is the smallest roll with a Decile larger than 6, and a Name of broomfield school?
SQL: SELECT MIN("roll") FROM amberley_school WHERE "decile" > 6 AND "name" = 'broomfield school'

Question: Which name has a Roll of 270?
SQL: SELECT "name" FROM amberley_school WHERE "roll" = 270