I want to output a list showing the count of each type of Category in my Ledger table.
Table - Ledger
Field - CategoryName
(There’s other fields, but there not important for this situation).
Output I’m looking for example
Entertainment - 20 (There’s a total of 20 entries in the Ledger table where CategoryName is Entertainment)
Education - 4 (There’s a total of 4 entries in the Ledger table where CategoryName is Education)
Personal Care - 9
I’m having a hard time figuring this out. Any help would be very much appreciated.
Here’s an example from Stack Overflow where someone wants to do what I’m doing in SQL