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

Question: What was the gender for the integrated authority with a roll of 142?
SQL: SELECT "gender" FROM arakura_school WHERE "authority" = 'integrated' AND "roll" = 142

Question: What was the Authority for Avalon School with a roll less than 358?
SQL: SELECT "authority" FROM arakura_school WHERE "area" = 'avalon' AND "roll" < 358 AND "name" = 'avalon school'

Question: Who is the authority for the coed Eastbourne school?
SQL: SELECT "authority" FROM arakura_school WHERE "area" = 'eastbourne' AND "gender" = 'coed'