select staff_info.name,pro_name,round(sum(effort)/(22*8),2) sum_effort
from task_info,pro_info,staff_info
where task_info.staff_sril=staff_info.staff_sril and task_info.pro_sril=pro_info.pro_sril
group by cube(staff_info.name,pro_name)
order by pro_name
个人工作量投入统计
最新推荐文章于 2024-08-18 18:53:10 发布