I have a table with a col that stores names. What I would like to do is determine the sum of records grouped by the first letter of the name. i.e give me a sum of all names starting with A,B,C etc...

The o/p should look like
Name: Count:
A 10
B 45
C 0
D 93

etc


Thanks