SELECT * FROM posts GROUP BY year

SELECT * FROM posts GROUP BY year

2025 20
2024 4