Table: auckland_schools_2
Columns: name
years
area
authority
decile
roll

Question: What area is the school with a decile of 8 in?
SQL: SELECT "area" FROM auckland_schools_2 WHERE "decile" = '8'

Question: Which school has a state authority and a roll of 318?
SQL: SELECT "name" FROM auckland_schools_2 WHERE "authority" = 'state' AND "roll" = 318

Question: In what area is torbay school with a state authority?
SQL: SELECT "area" FROM auckland_schools_2 WHERE "authority" = 'state' AND "name" = 'torbay school'