Table: taranaki_schools
Columns: name
years
area
authority
decile
roll

Question: What is the total decile in the area of Normanby with a roller smaller than 157?
SQL: SELECT SUM("decile") FROM taranaki_schools WHERE "area" = 'normanby' AND "roll" < 157

Question: What Authority has a decile greater than 5, with a roll of 170?
SQL: SELECT "authority" FROM taranaki_schools WHERE "decile" > 5 AND "roll" = 170