Q&A for administrators, end users, developers and designers for Craft CMS
SELECT Class,count(Id) as BadgeCount FROM Badges WHERE year(Date)= 2016 and month(Date) = 1 GROUP BY Class ;