user: ### NOW ANSWER:
Question: What is the roll number of the school with a State authority in Waiotira?
Columns: ['Name', 'Years', 'Area', 'Authority', 'Decile', 'Roll']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Blomfield Special School and Resource Centre', '–', 'Whangarei', 'State', '4', '72']
SQL:

assistant: SELECT "Roll" FROM "Table" WHERE "Authority" = 'State' AND "Area" = 'Waiotira';