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

Question: What Decile has State Authority and Raumati South Area?
SQL: SELECT "decile" FROM kapanui_school WHERE "authority" = 'state' AND "area" = 'raumati south'

Question: What is the total Decile with Waikanae Area?
SQL: SELECT SUM("decile") FROM kapanui_school WHERE "area" = 'waikanae'