CREATE TABLE table_55791 ("Name" CLOB, "Years" CLOB, "Gender" CLOB, "Area" CLOB, "Authority" CLOB, "Decile" FLOAT, "Roll" FLOAT)

What is the highest Roll of Orere School with a Decile less than 8 with a State Authority?
SELECT MAX("Roll") FROM table_55791 WHERE "Decile" < '8' AND "Authority" = 'state' AND "Name" = 'orere school'
SELECT MAX("Roll") FROM "table_55791" WHERE "Authority" = 'state' AND "Decile" < '8' AND "Name" = 'orere school'