SELECT AF_DEPARTMENT, dept.FULLNAME, SUM(CASE AF_CLASSIFY WHEN THEN ELSE END) AS 'o_standard', (COUNT(AF_DEPARTMENT) - SUM(CASE AF_CLASSIFY WHEN THEN ELSE END)) AS AND AF_CLASSIFY = ,,)) AS AND AF_CLASSIFY != ,,)) AS ,,) ) AS ,,))) AS 'non_enter' FRO