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

Question: Which years have a Decile of 4, an Authority of state, and a Name of mapiu school?
SQL: SELECT "years" FROM aria_school WHERE "decile" = 4 AND "authority" = 'state' AND "name" = 'mapiu school'

Question: Which years have a Decile smaller than 6, an Area of te kuiti, and an Authority of state integrated?
SQL: SELECT "years" FROM aria_school WHERE "decile" < 6 AND "area" = 'te kuiti' AND "authority" = 'state integrated'

Question: What is the average Decile with a state authority and a Name of mapiu school?
SQL: SELECT AVG("decile") FROM aria_school WHERE "authority" = 'state' AND "name" = 'mapiu school'

Question: Which years have an Area of rangitoto?
SQL: SELECT "years" FROM aria_school WHERE "area" = 'rangitoto'

Question: Which gender has a Name of rangitoto school?
SQL: SELECT "gender" FROM aria_school WHERE "name" = 'rangitoto school'