SQL UPDATE arithmetic question

Question

In the SQL UPDATE practice exercises, the Pay Raises question asks to update the salary values in the company table for employees with greater than a 5 rating.
I need some guidance on the proper formatting for doing arithmetic in SQL queries.
My best guess is below, but it does not work:

/*
UPDATE company
SET salary = salary + salary*0.2
WHERE rating > 5;
*/

Answer 1

first update then select...

UPDATE company
SET salary = salary + salary*0.2
WHERE rating > 5;

SELECT * FROM company;

Answer 2

Can you put the whole question here. So we can help you

Answer 3

As it is a pro code coach, so I can't see it.
I think your solution is right and be sure you also give
Select * from company;
command

Answer 4

Sure:

Write a query to increase salaries by 20% for those employees whose rating is above 5.
Then show the updated table.

Source: https://sololearn.com/coach/1011/?ref=app

Answer 5

Like this?

/*
SELECT * FROM company;
UPDATE company
SET salary = salary + salary*0.2
WHERE rating > 5;
*/

Answer 6

UPDATE company
SET salary = salary*1.2
WHERE rating > 5;
SELECT * FROM company;

Answer 7

UPDATE company
SET salary = salary + salary*0.2
WHERE rating > 5;

SELECT * FROM company;

Answer 8

UPDATE company
SET salary = salary * 1.2
WHERE rating > 5;

SELECT * FROM Company;