# 方法二: # 按最小颗粒度进行细分聚合之后,再按部门进行聚合模糊了性别 # 按性别加权平均反推出员工综合平均薪资 select department, round(sum(total)/sum(nums),2) average_actual_salary, round(sum(average_salary_male),2) average_actual_salary_male, round(sum(average_salary_female),2)average_actual_salary_female from( select department, staff_gender, sum(...