Hi Chandugg,
Please try following solution. In this solution I create a full example but you can see only final query.
Create Table empp
(Id int identity(1,1) primary key,
Employee_Id int,
hire_date datetime
)
insert into empp(Employee_Id,hire_date)
values (1,'1987-09-17 00:00:00.000'),
(1,'1989-09-21 00:00:00.000'),
(1, '1990-01-03 00:00:00.000'),
(1,'1991-05-21 00:00:00.000'),
(1,'1993-01-13 00:00:00.000'),
(4,'1994-06-07 00:00:00.000'),
(1, '1994-08-16 00:00:00.000'),
(1,'1994-08-17 00:00:00.000'),
(1,'1994-12-07 00:00:00.000')
Select DATEPART(yyyy,hire_Date), count(Employee_Id) from empp
Group by (DATEPART(yyyy,hire_Date))