title: Update table column values based on conditional logic
body: <p>I have table like this:</p>
  
  <pre><code>name | salary 
  Tom  | 10000
  Mary | 20000
  Jack | 30000
  Lisa | 40000
  Jake | 60000
  </code></pre>
  
  <p>I need an update query to update the salary column depending on the values it contains.</p>
  
  <p>Salaries need to increase by:</p>
  
  <ul>
  <li>5000 for values between 10000 to 15000 </li>
  <li>7000 for values between 15000 to 20000</li>
  <li>8000 for values between 20000 to 30000</li>
  <li>10000 for values between 40000 to 60000</li>
  </ul>