Starting at the bottom

Problem

Management approved a raise of 150 a month and wants to start at the bottom: it goes to whoever earns the least in each department. If two people share their department's lowest salary, both get it. In a department of one, that one person is the lowest paid.

Carol has no department, and her salary stays as it is.

Write the change. It's graded by looking at every salary in the company afterward, so it can't give anyone a raise they weren't due.

What it has to return

SELECT id, name, salary FROM employees;

This is what comes out with the data in the practice database this challenge uses. The column names don’t count, so name yours however you like: what counts is how many there are and the order they come in. Besides this one, the challenge has hidden tests with other data that are revealed when you submit your solution.

You start with this

UPDATE employees
SET salary = salary + 150
WHERE salary = (
  SELECT MIN(salary)
  FROM employees
);