Yeah, it works perfect!
Now, I'd like to count the months of the same year.
If I want to count the years, I can do like this, right?
SELECT DISTINCT name, YEAR(date), COUNT(name)
GROUP BY name, YEAR(date)
How can I count the months of the same year? We cant use MONTH(date) as it might include counts of the months of different years.
Thanks a lot!