UPDATE Store
SET Store.star = b.a
FROM Store AS S, (SELECT Avg(Review.star) AS a, sId FROM Review GROUP BY sId) AS b
WHERE S.sId = b.sId AND S.address LIKE '%大安區%' AND S.city = 'Taipei'