title: Add a number to all rows. SQL query
body: <p>suppose I want to add a $2500 bonus to all income column. How to achieve it?e.g.</p>
  
  <pre><code>Old table:
  id name     salary
  1  John     8000
  2  Labron   5000
  3  Elvis    6000
  
  New table:
  id name     salary  SalaryWithBonus
  1  John     8000    10500
  2  Labron   5000    7500
  3  Elvis    6000    8500
  </code></pre>
  
  <p>Do I have to use PL/SQL function for this? I'm new in this field so please don't get annoyed if the question is kind of silly type. </p>