Following the example in Lecture 2, Print a report of salaries for HR.EMPLOYEES..

Set echo on

Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa2spool.txt

Set appropriate column headings and formats

Set appropriate linesize and pagesize. Give your report the title 'CS442a Module 2 Written Assignment'

Set a break on DEPARTMENT_ID and REPORT

Compute subtotals on DEPARTMENT_ID and a grand total on REPORT

Show just the fields DEPARTMENT_ID, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, and SALARY for Department_ID < 50 from HR.EMPLOYEES . (Don't forget to order by DEPARTMENT_ID.)

Close the spool file