title: how to add two row value and make one row in my sql
body: <p>given table: </p>
  
  <pre><code>   id price1 price2 type  
      1  25      24     A
      2  42      44     B 
      3  59      54     C
      4  85      58     D
  </code></pre>
  
  <p>desire</p>
  
  <pre><code>id price1 price2 type  
  1   67      68     A
  3   59      54     C
  4   85      58     D 
  </code></pre>
  
  <p>please suggest me how to implement this because i have tried using Sum function but its not make sense  i am not able to fix it issue please help 
  basically i have to add two row value and make type A .</p>