MySQL does not support GROUP_BY and HAVING on UPDATE, we need to use a Subquery.

Co-authored-by: Rafael Mendonça França <rafael@franca.dev>