query

Select gm.strat_a_name  ,Sum(gm.strat_a_score), gm.strat_b_name,Sum(gm.strat_b_score)
From generations as g
JOIN generation_match_up_results as gm on g.id = gm.generation_id
WHERE g.id = 20
GROUP BY gm.strat_a_name, gm.strat_b_name;



@Query(value = "SELECT g from Generation as g join g.generationMatchUpResults as gm " +
            "where g.id =:id " +
            "GROUP BY gm ")
Object[] getGenerationResultsByGenerationId(@Param("id") Long id);