b1nary0mega
12/11/2014 - 7:50 PM

Count Evaluations as a certain level for given year(s).

Count Evaluations as a certain level for given year(s).

SELECT EVAL_LEVEL,
  YEAR,
  COUNT(*) AS COUNT
FROM EVAL_EMPL_PR
WHERE EVAL_LEVEL = '01NN'
AND (YEAR LIKE '%2013%'
OR YEAR LIKE '%2014%')
AND EVAL_LEVEL = '01NN'
GROUP BY EVAL_LEVEL,
  YEAR
ORDER BY EVAL_LEVEL,
  YEAR;