Table: birchville_school
Columns: name
years
gender
area
authority
decile

Question: What years is the private school in upper hutt?
SQL: SELECT "years" FROM birchville_school WHERE "area" = 'upper hutt' AND "authority" = 'private'

Question: What school with a decile of 7 is in upper hutt?
SQL: SELECT "name" FROM birchville_school WHERE "decile" = '7' AND "area" = 'upper hutt'

Question: What authority is the coed school in pinehaven?
SQL: SELECT "authority" FROM birchville_school WHERE "gender" = 'coed' AND "area" = 'pinehaven'

Question: What years does plateau school serve?
SQL: SELECT "years" FROM birchville_school WHERE "name" = 'plateau school'

Question: Is Upper valley middle school public or private?
SQL: SELECT "authority" FROM birchville_school WHERE "name" = 'upper valley middle school'