$5.$ Your company is considering a $$250$ bonus for all employees. Create a report for the CEO that displays all employees $($with their last name, first name, salary, and phone number$)$ along with their new salary showing the additional $$250$ bonus. The display of the salary that includes the bonus should be labeled $$Bonus Salary$($use the AS alias SQL keyword for this$).$

$6.$ Write an SQL statement that subtracts $20$ from the salary column and then multiples that result by $5,$ creating a new column $($this subtracts $20$ from everyone$$s salary and then multiples their salary by $5).$

The output display should display last names, phone number, salaries, and the new calculated column $($label this new calculated column: $$New Adjusted Salaries$).$ The output will display all $107$ rows, below is a display of the first four records$/$rows of the output.

$7.$ Create an SQL statement that will display the average salary, the maximum salary, and the minimum salary for all the Sales Representatives $($that is they have a job$\_$id of SA$\_$REP$).$

$8.$ Create an SQL statement that will display the maximum salary and the minimum salary for all the Financial Accountants $($this specific job title is located in the column$/$attribute: job$\_$id and labeled as FI$\_$ACCOUNT$).$

Your output will look like this: