CREATE TABLE table_80008 ("Name" TEXT, "Years" TEXT, "Gender" TEXT, "Area" TEXT, "Authority" TEXT, "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'