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

Question: What is the average decile of the school with a state authority and a roll number of 888?
SQL: SELECT AVG("decile") FROM schools_auckland_2 WHERE "authority" = 'state' AND "roll" = 888

Question: What is the area of Mount Albert School?
SQL: SELECT "area" FROM schools_auckland_2 WHERE "name" = 'mount albert school'

Question: What years does Our Lady Sacred Heart School, which is state integrated, have?
SQL: SELECT "years" FROM schools_auckland_2 WHERE "authority" = 'state integrated' AND "name" = 'our lady sacred heart school'