Where is the coed school with state authority, a Decile larger than 6 and 26 enrolled?
CREATE TABLE "dunedin_city" (
  "name" text,
  "years" text,
  "gender" text,
  "area" text,
  "authority" text,
  "decile" real,
  "roll" real
);
SELECT "area" FROM "dunedin_city" WHERE "authority"='state' AND "decile">6 AND "gender"='coed' AND "roll"=26;