SQL and distinct

I'm having trouble on generating a report in MySQL. I have this table:

CREATE TABLE users (
    id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
    birthday DATE,
    title VARCHAR(255)
);

I need to generate a report that throws how many titles exist for a given month. My first idea was something like this:

SELECT COUNT(DISTINCT(MONTH(birthday)开发者_高级运维)) AS q 
  FROM users

Of course that only returns how many months exist in the records. What I need is something like this:

Month | Count
-------------
2     | 384
5     | 131
12    | 585

---

This should work:

SELECT MONTH(birthday), COUNT(*) AS BirthdayCount
FROM user
GROUP BY MONTH(birthday)

This will give you the month number and the count of the records in that month, thus what you are looking for.

---

Like this?

SELECT MONTH(birthday), COUNT(*)
FROM user
GROUP BY MONTH(birthday)

---

Even simpler:

SELECT MONTH(birthday), COUNT(*)
FROM user
GROUP BY 1

---

You need a GROUP BY month(birthday) in there.

select month(birthday), count(month(birthday)) 
from users 
group by month(birthday);