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

Question: For a school with authority of state and a roll of 798, what is the decile?
SQL: SELECT "decile" FROM allandale_school WHERE "authority" = 'state' AND "roll" = 798

Question: Murupara has a roll greater than 296 for what years?
SQL: SELECT "years" FROM allandale_school WHERE "roll" > 296 AND "area" = 'murupara'

Question: When a school has authority of state and a decile greater than 1, what is the roll number?
SQL: SELECT "roll" FROM allandale_school WHERE "authority" = 'state' AND "decile" > 1