Instructions:

Write your SQL statements in Oracle LIVE SQL. (Note: if you cut-and-paste SQL statements/clauses from Word or Powerpoint, you must retype any quotation marks in LIVE SQL or you will get an error). Run your SQL statements, evaluate the results. Cut-and-paste your correct SQL statements into this Word Document. All problems use the hr.employees table.

5. Write/run the SQL statement that would display the average salary of the employees grouped by the manager they report to (the manager_id). The output should display the manager_ids and the average salaries for each manager id.

6. Your company is considering a $500 bonus for all employees. Create a report for the CEO that displays all employees (by last name, first name) along with their current salary and new salary showing the additional $500 bonus. The display of the salary that includes the bonus should be labeled Bonus Salary