Badge stats queries

badges_issued_by_day.sql

SELECT 
    CAST(badge.validated_on AS DATE) AS day,
    COUNT(*) AS 'Badges Issued'
FROM
    badge
GROUP BY year(day), month(day), day(day);

badges_issued_by_month.sql

SELECT 
    CAST(badge.validated_on AS DATE) AS month,
    COUNT(*) AS 'Badges Issued'
FROM
    badge
GROUP BY year(month), month(month);

badges_issued_by_week.sql

SELECT 
    CAST(badge.validated_on AS DATE) AS week,
    COUNT(*) AS 'Badges Issued'
FROM
    badge
GROUP BY week(week);