/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 votes332 views2 answers
Get current year sql
SQL
13 votes354 views3 answers
Change data type postgresql
SQL
0 vote319 views1 answer
Postgresql isnull with max
SQL
5 votes365 views3 answers
Sql server utc to local
SQL
0 vote317 views2 answers
Show slave status mysql
SQL
11 votes361 views1 answer
Ddl view
SQL
0 vote309 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote344 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote326 views1 answer
Soql last week
SQL
3 votes331 views1 answer
Oracle list invalid password ORA-01017
SQL