title: Write a query to get the sum of similar ids to display on each record
body: <p>I want to calculate the sum of the same ids and display in each record. expected Sample is given below</p>
  <p><a href="https://i.stack.imgur.com/VJ5pG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VJ5pG.png" alt="Expectd result" /></a></p>