月次誕生日のSQLクエリ

SELECT CONCAT(MONTH(birthday), '-', YEAR(birthday)) AS month_year, COUNT(*) AS birthday_count FROM users GROUP BY month_year ORDER BY month_year;>>More