I am trying to figure out how to get the sum of systems_score column by systems. The data model is below:
systems systems_score System A 20 System A 10 System A 0 System B 20 System B 20 System B 20 System C 10 System C 15 System C 0
How do I return the sum for each
Systems - like below?
systems systems_score_total System A 30 System B 60 System C 25