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

Question: What is the highest decile of Tarras school, which had a state authority?
SQL: SELECT MAX("decile") FROM alexandra_school WHERE "authority" = 'state' AND "name" = 'tarras school'

Question: What is the decile of the school with a roll larger than 513?
SQL: SELECT SUM("decile") FROM alexandra_school WHERE "roll" > 513

Question: What is the area of Cromwell Primary school, which has a state authority?
SQL: SELECT "area" FROM alexandra_school WHERE "authority" = 'state' AND "name" = 'cromwell primary school'