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

Question: Which years have a Decile smaller than 2, and an Area of mohaka?
SQL: SELECT "years" FROM frasertown_school WHERE "decile" < 2 AND "area" = 'mohaka'

Question: Which gender has an Authority of state, Years of 1–8, and a Decile smaller than 10, and a Roll of 36?
SQL: SELECT "gender" FROM frasertown_school WHERE "authority" = 'state' AND "years" = '1–8' AND "decile" < 10 AND "roll" = 36

Question: Which roll has an Area of mahia?
SQL: SELECT "roll" FROM frasertown_school WHERE "area" = 'mahia'

Question: Which Decile has an Authority of state, a Roll smaller than 61, and an Area of kotemaori?
SQL: SELECT "decile" FROM frasertown_school WHERE "authority" = 'state' AND "roll" < 61 AND "area" = 'kotemaori'