Table: ascot_community_school
Columns: name
gender
area
authority
decile
roll

Question: What is the total decile with an Authority of state, and a Name of newfield park school?
SQL: SELECT SUM("decile") FROM ascot_community_school WHERE "authority" = 'state' AND "name" = 'newfield park school'

Question: What is the largest decile with a Roll larger than 34, a Gender of coed, and an Authority of state integrated, and an Area of georgetown?
SQL: SELECT MAX("decile") FROM ascot_community_school WHERE "roll" > 34 AND "gender" = 'coed' AND "authority" = 'state integrated' AND "area" = 'georgetown'

Question: What is the smallest roll with an Authority of state, a Name of newfield park school, and a Decile smaller than 2?
SQL: SELECT MIN("roll") FROM ascot_community_school WHERE "authority" = 'state' AND "name" = 'newfield park school' AND "decile" < 2

Question: Which name has an Area of makarewa?
SQL: SELECT "name" FROM ascot_community_school WHERE "area" = 'makarewa'

Question: Which name has a Gender of coed, and a Decile larger than 5, and a Roll of 131?
SQL: SELECT "name" FROM ascot_community_school WHERE "gender" = 'coed' AND "decile" > 5 AND "roll" = 131