Hello I Have An Table WIth Two Clumn Below
table datas
type date
Security 2019-02-26
Booking 2019-03-02
Booking 2019-02-26
Security 2019-02-28
Cleanliness 2019-02-26
i want to count data of every category type of current year Below
Output
Year 2019
Type Count
Security 2
Booking 2
Cleanliness 1
How to do this please tell me