GROUP BY YEAR(`date`)