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

Question: Name the sum of roll for morrinsville school
SQL: SELECT SUM("roll") FROM david_street_school WHERE "name" = 'morrinsville school'

Question: Name the authority for morrinsville college
SQL: SELECT "authority" FROM david_street_school WHERE "name" = 'morrinsville college'

Question: Name the years when decile was less than 7 for waitoa school
SQL: SELECT "years" FROM david_street_school WHERE "decile" < 7 AND "name" = 'waitoa school'

Question: Name the total number of roll for state authority and stanley avenue school with decile more than 5
SQL: SELECT COUNT("roll") FROM david_street_school WHERE "authority" = 'state' AND "name" = 'stanley avenue school' AND "decile" > 5