I have the following table:Name | Col1 | Col2 | Col3John A B CJohn A D ABill A A DBill F A ASteve F A BSteve C C AI want to know a total of how many As John, Bill, and Steve have...e.g. John: 3, Bill: 4, Steve: 2How could I do this using T-SQL? Thanks.
