Raise Every Engineering Salary by 10%

Write an UPDATE that gives every employee in the 'Engineering' department a 10% raise: new salary = FLOOR(salary * 1.1) (rounding down to the nearest whole number). Do not touch employees in other departments. The checker runs SELECT id, name, salary FROM employees ORDER BY id; afterward.

sql
CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  department TEXT NOT NULL,
  salary INTEGER NOT NULL
);

Sample data (this is the starting state before your statement runs):

sql
INSERT INTO employees (id, name, department, salary) VALUES
(1, 'Asha', 'Engineering', 80000),
(2, 'Rohan', 'Engineering', 70000),
(3, 'Neha', 'Sales', 60000);