What the total in the case one when it is more than 4 associate professor, 5 lecturer and fewer professor than 40?
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 Total FROM table WHERE Associate professors > 4 AND Lecturers = 5 AND Professors < 40
4 5 40