Your last desired output is not clear ,
but as per my understanding below is the query you are trying.
Select emp.Name , Count(emp.salary) as Count , Sum(emp.Salary) as Count_Salary
From Employee as emp with (nolock)
Group by emp.Name
Order by emp.Name
Just let me know if you have any further queries.