What is the highest Roll of Orere School with a Decile less than 8 with a State Authority?
CREATE TABLE "franklin_local_board" (
  "name" text,
  "years" text,
  "gender" text,
  "area" text,
  "authority" text,
  "decile" real,
  "roll" real
);
SELECT MAX("roll") FROM "franklin_local_board" WHERE "decile"<8 AND "authority"='state' AND "name"='orere school';