CREATE TABLE table_80008 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

What is the total of the roll with a Decile of 8, and an Area of hororata?
SELECT SUM("Roll") FROM table_80008 WHERE "Decile" = '8' AND "Area" = 'hororata'
SELECT SUM("Roll") FROM "table_80008" WHERE "Area" = 'hororata' AND "Decile" = '8'