Page 1 of 1
20 RESEARCH DALLAS 30 SALES CHICAGO EMP EMPNOENAME JOB MGR HIREDATESAL DEPTNO 7369 SMITH CLERK 7902 17-DEC-80800 20 7499
Posted: Fri May 20, 2022 10:49 am
by answerhappygod
- 20 Research Dallas 30 Sales Chicago Emp Empnoename Job Mgr Hiredatesal Deptno 7369 Smith Clerk 7902 17 Dec 80800 20 7499 1 (71.48 KiB) Viewed 24 times
20 RESEARCH DALLAS 30 SALES CHICAGO EMP EMPNOENAME JOB MGR HIREDATESAL DEPTNO 7369 SMITH CLERK 7902 17-DEC-80800 20 7499 ALLEN SALESMAN769820-FEB-81 160030 7654 MARTINSALESMAN769828-SEP-81 125030 7698 BLAKE MANAGER 783901-MAY- 285030 81 7782 CLARK MANAGER 783909-JUN-81 245010 7788 SCOTT ANALYST 7566 19-APR-87 300020 3.1. Display all information in the table EMP. (2) 3.2. Display all information in the table DEPT. (2) 3.3. Display the names and salaries of all employees with a salary less than 1000. (2) 3.4. Display the names and hire dates of all employees. (3) 3.5. Display the department number and number of clerks in each