The year is divided into 12 months. We can break down a month in four weeks.
In MySQL, how to return the week of the month? (Example: first week: 2 entries, second week: 5 entries, third week: 3 entries; fourth week: 8 entries)
Using Week and WeekOfYear not get the desired result because the functions return the week number YEAR, not month.
I'd like to make it clear that this is probably not a good way to divide your data - (see the comments), but that this will get you as close as you can get.