how to take sum of column with same id in 22jpql 3f 22

1public interface CodeRepository extends JpaRepository<Code, Integer> {
2    @Query("select c.code, c.name, count(l) as amount from Code c join c.counterList l group by c.code, c.name")
3    List<Object[]> getSummary();
4}
5