Table: blomfield_special_school_and
Columns: name
years
area
authority
decile
roll

Question: What is the roll number of Poroti school, which has a 6 decile?
SQL: SELECT "roll" FROM blomfield_special_school_and WHERE "decile" = '6' AND "name" = 'poroti school'

Question: What is the roll number of the school with a state authority in Waiotira?
SQL: SELECT "roll" FROM blomfield_special_school_and WHERE "authority" = 'state' AND "area" = 'waiotira'

Question: What is the area of the school with a decile of 2 and a roll number 222?
SQL: SELECT "area" FROM blomfield_special_school_and WHERE "decile" = '2' AND "roll" = '222'

Question: WHat is the decile of the school in Purua?
SQL: SELECT "decile" FROM blomfield_special_school_and WHERE "area" = 'purua'