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

Question: How many decile has a roll less than 20?
SQL: SELECT AVG("decile") FROM arrowtown_school WHERE "roll" < 20

Question: Which gender had a roll of 627?
SQL: SELECT "gender" FROM arrowtown_school WHERE "roll" = 627

Question: Glenorchy school has a decile less than 10 and is in what area?
SQL: SELECT "area" FROM arrowtown_school WHERE "decile" < 10 AND "name" = 'glenorchy school'

Question: Makarora primary school has a roll less than 141 and what gender?
SQL: SELECT "gender" FROM arrowtown_school WHERE "roll" < 141 AND "name" = 'makarora primary school'