Give a raise to employees of departments in one city

Tables:

department(id int primary key, city text)

employee(id int primary key, salary int, department_id int)

Write an UPDATE that raises the salary of every employee who works in a department located in 'Berlin' by 10 percent, rounded down (integer arithmetic: salary + salary / 10). Other employees, including those without a department, stay unchanged.

The result is checked by reading id, salary from employee ordered by id.

CREATE TABLE department (
  id int PRIMARY KEY,
  city text NOT NULL
);
CREATE TABLE employee (
  id int PRIMARY KEY,
  salary int NOT NULL,
  department_id int
);