I want a few columns and only if there are multiple appointment dates on the same day for an employee.

`Appointment` table

Initial

| employeeID | employeename | appointment\_date | type |
| --- | --- | --- | --- |
| 11 | James | 1/1/2020 | office |
| 11 | James | 1/1/2020 | meeting |
| 11 | James | 1//2020 | school |
| 12 | Marsha | 2/1/2020 | office |
| 13 | Shane | 3/1/2020 | school |
| 13 | Shane | 3/1/2020 | office |

Expected

| employeeID | employeename | appointment\_date | type | Count |
| --- | --- | --- | --- | --- |
| 11 | James | 1/1/2020 | office | 3 |
| 11 | James | 1/1/2020 | meeting | 3 |
| 11 | James | 1//2020 | school | 3 |
| 13 | Shane | 3/1/2020 | school | 2 |
| 13 | Shane | 3/1/2020 | office | 2 |

Marsha is excluded because there is only 1 appointment for that date

This is what I have so far:

```
SELECT 
    a.employeeID,
    a.appointment_date,
    a.type,
    (SELECT COUNT(a.employeeID) 
     FROM a.employeeID 
     GROUP BY a.employeeID 
     HAVING COUNT(a.employeeID) > 1)
FROM 
    appointment a
WHERE 
    a.date BETWEEN '1/1/2020' AND '12/31/2020'

```