1- Set echo on

2- Set up a spool file to receive your output for submission. I would suggest c:\cs4210\WA2spool.txt

3- Use the COLUMN statement to set the headings and formats for each column in HR.EMPLOYEES

4- Set appropriate linesize and pagesize. Give your report the title 'CS4210 Seminar 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 from HR.EMPLOYEES for Department_ID < 50 . (Don't forget to order by DEPARTMENT_ID.)

8- Close the spool file

I keep getting an error, what am I doing wrong? Here is my code:

SQL> SET ECHO ON SQL> SPOOL c:\App\WA2spool.txt SQL> START c:\App\WA2.txt SQL> COLUMN DEPARTMENT_ID FORMAT 99999 HEADING 'Department ID' SQL> COLUMN EMPLOYEE_ID FORMAT 99999 HEADING 'Employee ID' SQL> COLUMN FIRST_NAME HEADING 'First Name' SQL> COLUMN LAST_NAME HEADING 'Last Name' SQL> COLUMN SALARY FORMAT 9,999.99 HEADING 'Salary' SQL> SET LINESIZE 200 SQL> SET PAGESIZE 50 SQL> TTITLE LEFT 'CS4210 Seminar 2 Written Assignment' SQL> BREAK ON DEPARTMENT_ID SQL> COMPUTE SUM OF SALARY ON DEPARTMENT_ID SQL> COMPUTE SUM OF SALARY ON REPORT SQL> SELECT DEPARTMENT_ID, EMPLOYEE_ID, FIRST_NAME, LAST_NAME, SALARY 2 FROM HR.EMPOYEES 3 WHERE DEPARTMENT_ID < 50 4 ORDER BY DEPARTMENT_ID 5 / FROM HR.EMPOYEES * ERROR at line 2: ORA-00942: table or view does not exist