Hi all,

I want to make a query it which I count for each person the number of
encounters for each year.
So I want something like:
SELECT PersId, Extract (YEAR FROM EncDate) as EncYear, Count(Id) FROM
Encounter
GROUP BY PersId, EncYear ODER BY PersId, EncYear.

This is not correct. What is wrong?

Thanks,
Sibo