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

Question: What is the roll number of the school in Aramoho with a decile of 1?
SQL: SELECT "roll" FROM aberfeldy_school WHERE "area" = 'aramoho' AND "decile" = 1

Question: What is the area of Mangamahu primary school?
SQL: SELECT "area" FROM aberfeldy_school WHERE "name" = 'mangamahu primary school'

Question: What is the area of the coed school with a state authority and a roll number of 122?
SQL: SELECT "area" FROM aberfeldy_school WHERE "authority" = 'state' AND "gender" = 'coed' AND "roll" = 122