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

Question: What is the name of the school in Hillcrest?
SQL: SELECT "name" FROM auckland_schools_3 WHERE "area" = 'hillcrest'

Question: What are the years available at Bayview School, which has state authority and a roll number larger than 333?
SQL: SELECT "years" FROM auckland_schools_3 WHERE "authority" = 'state' AND "roll" > 333 AND "name" = 'bayview school'