b1nary0mega
9/17/2014 - 3:01 AM

Get a count of Evaluations for the year by type

Get a count of Evaluations for the year by type

SELECT COUNT(DISTINCT EMPL_ID) as EMPL_COUNT,
  EVAL_LEVEL,
  YEAR
FROM EVAL_EMPL_PR 
where EVAL_STATUS = 'Finalized'
AND YEAR = '2013-Annual'
GROUP BY EVAL_LEVEL, YEAR
ORDER BY EMPL_COUNT DESC, EVAL_LEVEL, YEAR;