使用Join和Group By更新语句

I have written the below Update Statement, but it shows the error such as "Incorrect syntax near the keyword 'GROUP'."I have written the below Update Statement, but