user: ### NOW ANSWER:
Question: What is the sum of the roll with an area of Waikaka?
Columns: ['Name', 'Years', 'Gender', 'Area', 'Authority', 'Decile', 'Roll']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['East Gore School', '1-6', 'Coed', 'Gore', 'State', 3.0, 102.0]
SQL:

assistant: SELECT SUM("Roll") FROM "Table" WHERE "Area" = 'Waikaka';