How may lecturer got case when got more than 8 assistant professor, fewer than 35 associate professor, more than 14 professor and total more than 81?
Lecturers Associate professors Assistant professors Professors Total
National Technical University of Athens
1064216
real real real real real
2-1064216-1
Academic staff
NTUA Academic Staff per School
5 35 27 40 120
9 10 8 58 96
12 16 17 23 81
5 12 8 20 55
18 20 9 34 119
6 13 10 48 78
7 14 5 15 49
4 10 9 14 51
2 4 8 14 28
SELECT COUNT Lecturers FROM table WHERE Assistant professors > 8 AND Professors > 14 AND Associate professors < 35 AND Total > 81
8 14 35 81