update employee from (
select
          sum(hours_worked) as hours_worked,
          employee_id
from
      employee_activity
group by 
      employee_id
) t1 
set employee.hours_worked_last_week = t1.hours_worked
where
 employee.employee_id = t1.employee_id