Advertisement
Guest User

Untitled

a guest
Oct 21st, 2017
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. UPDATE Store,(SELECT avg(Review.star) AS a, sId
  2.               FROM Review GROUP BY sId) b2
  3. SET Store.star = b2.a
  4. WHERE b2.sId=Store.sId AND city='Taipei' AND address LIKE '%大安區%'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement