Name the highest In/de-creased which has a Percentage in/de-crease of 100%, and Seats 2010 larger than 8?
CREATE TABLE "seat_allocation" (
  "governorate" text,
  "seats_2010" real,
  "seats_2005" real,
  "in_de_creased_by" real,
  "percentage_in_de_crease" text
);
SELECT MAX("in_de_creased_by") FROM "seat_allocation" WHERE "percentage_in_de_crease"='100%' AND "seats_2010">8;