CREATE and thoroughly test a PL$/$SQL coded solution for the following problem

The president of the company wants to ensure that everyone is receiving a $$fair$$ wage. He

has asked you to modify salaries of everyone, except him, using the following guidelines

$($each point uses the salary from the previous step unless otherwise specified$)$:

$$ If anyone makes more than the president does, they should have their salaries