total number of records and their reason sql server : I want to write a query that get total number of records(booking) using COUNT(*) function, i have a column in DB "Type" and in the next column i want to show type of record e.g output of query be like

Total Booking -> 10

Booking Type -> 3 wedding, 4 Birthday Party, 3 family Event (this will be in single cell next to total Booking)

someone please help me.. Thanks