finished the following SQL Statements. APPENDIX: SCOTT DATABASE - TABLES Table Name : EMP1 EMPNO ENAME JOB 7369 SMITH CLERK MGR HIREDATE SAL COMM DEPTNO 7902 17/DEC/80 875.77 20 7499 ALLEN SALESMAN 7698 20/FEB/81 1600 300 30 #Table Name : DEPTI DEPTNO DNAME LOC VO2 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 1. Display all rows from the DEPT1 table. 2. Display each job and the average salary of all people in that job. 3.Display the employee number and name for all employees who work in the same department as ALLEN 4. Display the department no and the number of employs of this department. 3.Display the name and salary of employees who earn more than $1600 and are in department 10 or 20. Label the columns Name and Monthly Salary. |