title: SQL question need to add the values in one column and remove duplicates after adding the columns in another column
body: <p>I want to add the column values based on the remove duplicates in another column</p>
  
  <p>Need the data like as shown below:</p>
  
  <p><a href="https://i.stack.imgur.com/pLahd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pLahd.png" alt="enter image description here"></a></p>