Name the authority for te akau with roll less than 254 and decile of 8
CREATE TABLE "waikato_district" (
  "name" text,
  "years" text,
  "gender" text,
  "area" text,
  "authority" text,
  "decile" text,
  "roll" real
);
SELECT "authority" FROM "waikato_district" WHERE "roll"<254 AND "decile"='8' AND "area"='te akau';