Making a Group By month in MySQL is much easier than expected. Just need to have a bit of understanding on the query.
MySQL Group By Month
Group By is one of the most required functions of MySQL. Ask those who dont know how to utilise it, or maybe if there exist any awkward databases where Group By is not supported.
To do a group by month, all u need to do is to run the following query. But hey, its better if you try to understand what its actually doing so you may be able to utilize it better even in the future.
SELECT COUNT(id), DATE_FORMAT(your_date_field, "%M") Months FROM table_name GROUP BY Months;
where id is the main primary key of your table and your_date_field is the date field name, which you want to use for date conversion.