title: How to write SQL statement in this case?
body: <p>For some reason, I'd like to change the database. </p>
  
  <p>It's not possible to change these values manually one by one as there are so much records. </p>
  
  <p>Please advise how to write this SQL, thanks.</p>
  
  <p>From:</p>
  
  <pre><code> id  percentage    type
    1     6        services
    1     10       testing
    3     8        services
    3     20       testing
    6     61       services
    6     90       testing
  </code></pre>
  
  <p>To:</p>
  
  <pre><code>id percentage    type
  1     10       services
  1     10       testing
  3     20       services
  3     20       testing
  6     90       services
  6     90       testing
  </code></pre>