Written Assignment-Submitting an HR Spool File Points: 60

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

1. Set echo on
2. Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa2spool.txt
3. Set appropriate column headings and formats
4. Set appropriate linesize and pagesize. Give your report the title 'CS442a Module 2 Written Assignment'
5. Set a break on DEPARTMENT_ID and REPORT
6. Compute subtotals on DEPARTMENT_ID and a grand total on REPORT
7. 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.)
8. Close the spool file