Check this sample
--Create sample table with data
declare @tbl table (id int,name varchar(100), [key] int)
insert into @tbl
select 1,'ali', 10
union all
select 2,'amir', 2
union all
select 3,'reza', 5
union all
select 4, 'ali', 1
union all
select 5, 'amir', 25
union all
select 6, 'amir', 7
--Result query
select name, count(name) keycount from @tbl
group by name