Table: arthur_miller_school
Columns: name
years
gender
area
authority
decile

Question: Which area has a Name of william colenso college?
SQL: SELECT "area" FROM arthur_miller_school WHERE "name" = 'william colenso college'

Question: Which authority has a Name of tamatea high school?
SQL: SELECT "authority" FROM arthur_miller_school WHERE "name" = 'tamatea high school'

Question: Which gender has a Decile of 8, an Area of taradale, and Years of 1–13?
SQL: SELECT "gender" FROM arthur_miller_school WHERE "decile" = 8 AND "area" = 'taradale' AND "years" = '1–13'

Question: Which Decile has Years of –, and a Gender of coed?
SQL: SELECT "decile" FROM arthur_miller_school WHERE "years" = '–' AND "gender" = 'coed'