Cacher is the code snippet organizer for pro developers

SELECT 
monthname(created_at) as month,
year(created_at) as year,
count(*) published
FROM posts
GROUP BY year, month
ORDER BY min(created_at) desc