Update Using a Join

Increase the salary of every employee in the 'Engineering' department by 10%.

Table schema

Employees(id INT PRIMARY KEY, name VARCHAR(50), department_id INT, salary INT)
Departments(id INT PRIMARY KEY, name VARCHAR(50))

Sample data

Employees:
id | name | department_id | salary
1 | A | 1 | 1000
2 | B | 2 | 1000

Departments:
id | name
1 | Engineering
2 | HR