I am using sqlplus

8. Create a query that will display the employee name, department number, and all the employees that work in the same department as a given employee. Give each column an appropriate label DEPARTMENT EMPLOYEE COLLEAGUE CLARK KING CLARK MILLER 10 10 10 10 10 MILLER CLARK 10 MILLER KING 20 20 20 20 20 20 20 KING CLARK KING MILLER ADAMS FORD ADAMS JONES ADAMS SCOTT ADAMS SMITH FORD ADAMS FORD JONES FORD SCOTT 56 rows selected. 9. Show the structure of the SALGRADE table. Create a query that will display the name, job, department name, salary, and grade for all employees Name GRADE Null? Type NUMBER