CREATE TABLE table_55791 ("Name" TEXT, "Years" TEXT, "Gender" TEXT, "Area" TEXT, "Authority" TEXT, "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'