Something

update employee from (select          sum(hours_worked) as hours_worked,          employee_idfrom      employee_activitygroup by       employee_id) t1 set employee.hours_worked_last_week = t1.hours_workedwhere employee.employee_id = t1.employee_id