求助:修改表中的每一项

我想把表lab_students中的last_mark修改为select avg(Cou_mark) as last_mark from lab_stu_course group by user_ID的执行结果last_mark
lab_students表是这样的
user_ID char
dept_ID int
major_ID int
mark int
last_mark int