user: Question: What is the highest roll number of the school with a State authority and a decile smaller than 8?
Columns: ['Name', 'Years', 'Gender', 'Area', 'Authority', 'Decile', 'Roll']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['Fairhaven School', '1–6', 'Coed', 'Te Puke', 'State', 5.0, 389.0]
SQL:

assistant: SELECT MAX("Roll") FROM "Table" WHERE "Authority" = 'State' AND "Decile" < 8.0;