title: ERROR: syntax error at or near "group"
body: <p>Hello I'm writing an sql query But i am getting a syntax error on the line with the GROUP BY. What can possibly be the problem, help if you can please.</p>
  
  <pre><code>UPDATE intersection_points i
    SET nbr_victimes = sum(tue+bl+bg)
      FROM accident_ma a ,intersection_points i 
      WHERE (ST_DWithin(i.st_intersection,a.geom_acc, 10000) group by st_intersection)) ;
  </code></pre>