Hi ps222,

Refer below sample query to get Count Yearwise.

SELECT DATEPART(YEAR,OrderDate) [Year],COUNT(OrderDate) [Count] 
FROM Orders
GROUP BY DATEPART(YEAR,OrderDate)

Then display record as per your output use pivot query.

Pivot query with dynamic columns in SQL Server