Oracle syntax - Table names are in the order they appear

DEPARTMENT

EMPLOYEE

PROJECT

WORKS

A. Report the employee numbers and roles of employees in the Production department working on the Database project.

B. Report the names of employees who earn an above-average salary.

C. Report the names of employees in the Production Department who have an above average salary for employees in the Production Department.

D. Retrieve the employee name, employee salary, and the employee's department number of any employee whose salary is above the average for his or her department.

E. Retrieve the name, department number, department name, and salary of any employees whose salary is above the average for his or her department.

COLUMN_NAMEDATA TYPE 1 DEPARTNO 2 DEPTNAME VARCHAR2 (20 BYTE) Yes 3 DEPTLOCATION VARCHAR2 (50 BYTE) Yes 4 NUMBERSTAFF NUMBER (20,0) NULLABLE DATA DEFAULTCOLUMN IDCOMMENTS (urill) (null) (null) (null) 1 (null) 2 (null) 3 (null) 4 (null) NUMBER (10,0) No Yes NULLABLE DATA DEFAULTCOLUMN ID COMMENTS 1 (null) 2 (null) 3 (null) 4 (null) 5 (null) 6 (null) 7 (null) COLUMN NAME DATA TYPE 1 EMPLOYNO 2 EMPLOYLASTNAME VARCHAR2 (25 BYTE) Yes 3 EMPLOYFIRSTNAME VARCHAR2 (20 BYTE) Yes 4 EMPLOYSALARY NUMBER (38,2) 5 STARTDATE 6 BENEFITSNO 7 DEPARTNO NUMBER (10,0) No Tes Tes Tes Tes (null) (null) (null) (null) (null) (null) (null) DATE NUMBER (10,0) NUMBER (10,0) COLUMN NAME DATA TYPE NULLABLE DATA DEFAULTCOLUMN IDCOMMENTS 1 PROJECTNO NUMBER (10,o) 1 (null) 2 (null) 3 (null) 4 (null) No (null) (null) (null) (null) 2 PROJECTNAME VARCHAR2 (25 BYTE) Yes PROUECTTYPE VARCHAR2 (25 BYTE) Yes 4 BUDGET NUMBER (38,2) es COLUMIN NAME DATA_TYPE NULLABLE DATA DEFAULTCOLUMIN IDCOMMENTS 1 EMPLOYNO 2 PROJECTNO 3 ROLE NUMBER (10,0) NUMBER (10,0) VARCHAR2 (25 BYTE) Yes NULLABLE DATA DEFAULTCOLUMN IDCOMMENTS No No (null) (null) (null) 1 (null) 2 (null) 3 (null)