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

Question: What is the sum of the roll with an area of Waikaka?
SQL: SELECT SUM("roll") FROM southland_schools WHERE "area" = 'waikaka'

Question: What is the roll number for East Gore School?
SQL: SELECT COUNT("roll") FROM southland_schools WHERE "name" = 'east gore school'

Question: What is the lowest decile with 1-6 years and area of Maitland?
SQL: SELECT MIN("decile") FROM southland_schools WHERE "years" = '1-6' AND "area" = 'maitland'

Question: Which gender has 7-15 years?
SQL: SELECT "gender" FROM southland_schools WHERE "years" = '7-15'

Question: What is the gender for Otama?
SQL: SELECT "gender" FROM southland_schools WHERE "area" = 'otama'

Question: What is the authority for roll of 96?
SQL: SELECT "authority" FROM southland_schools WHERE "roll" = 96