use DCF16_TEST;
with fbirthdayreps(fbirthday,yearcount)as
( select year(fBirthday),COUNT(*)
FROM t_PALM_Employees AS fbirthday
WHERE FBIRTHDAY IS NOT NULL
GROUP BY year(fbirthday)
)
SELECT fbirthday,yearcount
FROM fbirthdayreps