/SQL/How to take sum of column with same id in "JPQL?"

How to take sum of column with same id in "JPQL?"

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

Source: stackoverflow.com

Similar codes

3 votes188 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
3 votes219 views2 answers
Enter mysql command line
SQL
3 votes174 views1 answer
Sql replace character in string in all records
SQL
0 vote183 views2 answers
How to add CHECK constraint to a column in postgres
SQL
20 votes185 views5 answers
Reset auto increment mysql
SQL
8 votes176 views1 answer
Script to add datafile to tablespace
SQL
0 vote189 views3 answers
Join
SQL
0 vote160 views1 answer
Cross apply top for each row t1
SQL
0 vote169 views1 answer
If column value is null then in mysql
SQL
0 vote169 views1 answer
Group by sql not ordering issues
SQL