/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

2 votes179 views2 answers
Mysql show table column comments sql
SQL
0 vote191 views1 answer
Use mysql in java program
SQL
0 vote185 views1 answer
Mysql timediff
SQL
1 vote200 views1 answer
Oracle columns table
SQL
5 votes179 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
11 votes164 views2 answers
Sql between date range
SQL
1 vote173 views1 answer
Sql Split string function
SQL
2 votes183 views1 answer
Q operator in plsql
SQL
0 vote177 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote166 views1 answer
Postgresql default value boolean
SQL