refernce data in db
| emp_id | date |
|---|---|
| 1111 | 08-09-22 |
| 2222 | 08-09-22 |
| 3333 | 08-09-22 |
| 2222 | 08-09-22 |
| 3333 | 08-09-22 |
| 1111 | 09-09-22 |
| 3333 | 09-09-22 |
| 3333 | 09-09-22 |
| 2222 | 10-09-22 |
| 2222 | 10-09-22 |
| 2222 | 10-09-22 |
expected result
| emp_id | 08-09-22 | 09-09-22 | 10-09-22 | total |
|---|---|---|---|---|
| 1111 | 1 | 1 | 0 | 2 |
| 2222 | 2 | 0 | 3 | 5 |
| 3333 | 2 | 2 | 0 | 4 |