title: How to increase a numeric attribute value in a database by a percentage using SQL
body: <p>I have 2 tables in a database as follows;</p>
  
  <pre><code>Instructor (id, name, department_id, salary)
  Department (department_id, dep_name, location)
  </code></pre>
  
  <p>I want to increase the salary of a set of Instructors in a particular department, say I want to increase the salary of all instructors from Physics Department (say department id=1) by 10%. How can I do that using an sql query?</p>