human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Name, Years, Gender, Area, Authority, Decile, Roll
###Question: What is the total of the roll with a Decile of 8, and an Area of hororata?
gpt
SELECT SUM Roll FROM table WHERE Decile = 8 AND Area = hororata