```sql SELECT date_trunc('month', created_at) AS month, COUNT(id) as cpt FROM reference GROUP BY month ORDER BY month; ```