Please note that id as identity, so using count (*) do not deliver the last record but much better to use max (id).

Besides the set should be:

set salary = salary * 1.15

dividing machines are bad.