One raise, not two

Problem

This year's raise goes by bracket, and the bracket goes by monthly salary: 10% for anyone who earns less than 2500, and 5% for anyone who earns 2500 or more but less than 3500. From 3500 up there's no raise, so Carol and the managers stay where they are.

What sets the bracket is today's salary, the one from before anything gets touched, and nobody gets both raises.

Write the change. Every salary ends in 00, so no raise leaves decimals. It's graded by looking at where every salary in the company ends up.

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 * 1.1
WHERE salary < 2500;