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

Question: Where is the coed school with state authority, a Decile larger than 6 and 26 enrolled?
SQL: SELECT "area" FROM abbotsford_school WHERE "authority" = 'state' AND "decile" > 6 AND "gender" = 'coed' AND "roll" = 26

Question: What is the average roll for Fairfield school?
SQL: SELECT AVG("roll") FROM abbotsford_school WHERE "name" = 'fairfield school'

Question: Which school has a roll larger than 26 and is located in Fairfield?
SQL: SELECT "name" FROM abbotsford_school WHERE "roll" > 26 AND "area" = 'fairfield'