In my VarChar Column, 'ZZ', I have 3 possibilities with a total of 134 rows :
I need to create a table to show a total of each of these possibilities that are listed.
aaaa bbbb cccc
53 47 34 TOTAL
Please provide an expression that I can use to obtain each of the 3 totals.