SelectDeptName=O.OUName,'9G'=Sum(Case When PersonalGrade=9 Then 1 Else 0 End),'8G'=Sum(Case When PersonalGrade=8 Then 1 Else 0 End),'7G4'=Sum(Case When PersonalGrade=7 AND JobGrade =4 Then 1 Else 0 End),'7G3'=Sum(Case When PersonalGrade=7 AND JobGrade =3 Then 1 Else 0 End),'6G'=Sum(Case When PersonalGrade=6 Then 1 Else 0 End),'5G3'=Sum(Case When PersonalGrade=5 AND JobGrade =3 Then 1 Else 0 End),'5G2'=Sum(Case When PersonalGrade=5 AND JobGrade =2 Then 1 Else 0 End),'4G'=Sum(Case When PersonalGrade=4 Then 1 Else 0 End),'3G2'=Sum(Case When PersonalGrade=3 AND JobGrade =2 Then 1 Else 0 End),'3G1'=Sum(Case When PersonalGrade=3 AND JobGrade =1 Then 1 Else 0 End),'2G'=Sum(Case When PersonalGrade=2 Then 1 Else 0 End),'1G'=Sum(Case When PersonalGrade=1 Then 1 Else 0 End),--' 未定级'=Sum(Case When PersonalGrade=NULL Then 1 Else 0 End)
