求SQLServer SQL, SQLServer 如何通过上级用户名和岗位编码,获取所有下属包括隔级下属人数和分数总和及平均值
Id username managername userpositioncode managerpositioncode score
1 liyuan wanqiang A1 B1 3.1
2 wangxi wanqiang A2 B1 3.2
3 wanqiang aihua B1 C1 3.3
4 sunl aihua B2 C1 3.7
5 gaohui fany B4 C2 3.5