Group query by month and year

SELECT YEAR(created_at) as year,
MONTHNAME (created_at) as month,
COUNT(*) as published
FROM posts
GROUP BY year, month