I would like to get the number of employees that joined on a specific month. Below is my sample data.

[![enter image description here](https://i.stack.imgur.com/SKaD1.png)](https://i.stack.imgur.com/SKaD1.png)

If there are no employees that joined on a month the query should show zero like so,

[![enter image description here](https://i.stack.imgur.com/7Y27L.png)](https://i.stack.imgur.com/7Y27L.png)

I have come up with something like this but this only shows the months when there is a joinee on a specific month,

```
SELECT 
    COUNT(*) AS count,
    CASE
        WHEN MONTH(startDate) = 1 THEN 'JAN'
        WHEN MONTH(startDate) = 2 THEN 'FEB'
        WHEN MONTH(startDate) = 3 THEN 'MAR'
        WHEN MONTH(startDate) = 4 THEN 'APR'
        WHEN MONTH(startDate) = 5 THEN 'MAY'
        WHEN MONTH(startDate) = 6 THEN 'JUN'
        WHEN MONTH(startDate) = 7 THEN 'JUL'
        WHEN MONTH(startDate) = 8 THEN 'AUG'
        WHEN MONTH(startDate) = 9 THEN 'SEP'
        WHEN MONTH(startDate) = 10 THEN 'OCT'
        WHEN MONTH(startDate) = 11 THEN 'NOV'
        WHEN MONTH(startDate) = 12 THEN 'DEC'
    END AS SMonth
FROM
    Reports
GROUP BY SMonth

```

I am using ***mysql***.

***EDIT***

The Reports table has data spanning different years for e.g data from 1988,2012,2015 etc so there could be data with joinee in Jan 2015 but not in Jan 2018