SELECT e.department, SUM(ar.actual_work_hours) AS total_work_hours
FROM attendance_records ar
JOIN employees e ON ar.employee_id = e.employee_id
GROUP BY e.department;
利唐i人事HR社区，发布者：HR_learner，转转请注明出处：https://www.ihr360.com/hrnews/20241224202.html
