How to write a following SQL query in doctrine2 as DQL .
SELECT COUNT(id)
FROM stats
WHERE YEAR(record_date) = 2009
GROUP BY YEAR(record_date), MONTH(record_date)
i.e i would like to group by results based on month,year of datetime field stored in MySQL table.