How may lecturers are there in the case when there are more than 8 assistant professors, fewer than 35 associate professors, more than 14 professors and total of more than 81?
CREATE TABLE "ntua_academic_staff_per_school" (
  "lecturers" real,
  "associate_professors" real,
  "assistant_professors" real,
  "professors" real,
  "total" real
);
SELECT COUNT("lecturers") FROM "ntua_academic_staff_per_school" WHERE "assistant_professors">8 AND "professors">14 AND "associate_professors"<35 AND "total">81;