title: MySQL query giving 5% bonus to employee whose salary is less than average salary
body: <p>I'm a beginner in MySQL. I have a table named <strong>Employee</strong> and have a column <strong>Salary</strong>. I'm trying to give 5% bonus to employee table whose salary is below average salary. I don't know where i did mistakes. Can anyone tell me where's the wrong?</p>
  
  <p><strong>I tried this SQL:</strong>
  update employee 
  set salary = salary * 1.05
  where salary &lt; (select avg(salary) from employee)</p>