I have a table
Student Exp Edu
A 8 12
B 8 11
C 9 CD
D 9 DH
E 10 9
F 10 2
G 5 3
H 4 TC

I want count how many student same as:
Cap I (Edu <5)
Cap II (Edu 5<x<=9)
Cap III (Edu 9<x<=12)
TC, CD: (Edu x = TC + CD)
DH: (Edu x= DH)
How i do that function?