[Mysql] Group by Year & Count

[piero.mac]

select count(*) as tot
from tabella
GROUP BY YEAR(campo_datetime)