Sql query report

Has anyone tried these kind of sql reporting using sql query ? I am looking for some inputs on how to generate this summary report from one table say Employee that has data as shown in the sample table. The report need to have counts/sum of the employee names, and the list if individual employee names as shown in the sample report. Any help is appreciated. Thank you!

SSRS is what you would be looking for.