how to group the table by its column item

DECLARE @temp TABLE (NAME CHAR(3), GROUP1 CHAR(2))

INSERT INTO @temp (NAME, GROUP1)
VALUES 
     ('AAA', 'A'),     
     ('AAA', 'B'),
     ('AAA', 'A'),
     ('AAA', 'C')
 SELECT
      NAME
    , A = COUNT(CASE WHEN GROUP1 = 'A' THEN 1 END)
    , B = COUNT(CASE WHEN GROUP1 = 'B' THEN 1 END)
    , C = COUNT(CASE WHEN GROUP1 = 'C' THEN 1 END)
FROM @temp
GROUP BY NAME

declare @data table (name varchar(50),[group] varchar(50))

insert into @data (NAME, [GROUP])
values  ('AAA', 'A'), ('AAA', 'B'), ('AAA', 'A'), ('AAA', 'C'), ('BBB', 'A'), ('BBB', 'B'), ('BBB', 'B')

select name, A,  B, C
from (select name, [group], count([group]) count from @data group by name, [group]) src
pivot (sum([count]) FOR [group] in ( [A], [B], [C])) pvt