20 RESEARCH DALLAS 30 SALES CHICAGO EMP EMPNOENAME JOB MGR HIREDATESAL DEPTNO 7369 SMITH CLERK 7902 17-DEC-80800 20 7499

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

20 RESEARCH DALLAS 30 SALES CHICAGO EMP EMPNOENAME JOB MGR HIREDATESAL DEPTNO 7369 SMITH CLERK 7902 17-DEC-80800 20 7499

Post by answerhappygod »

20 Research Dallas 30 Sales Chicago Emp Empnoename Job Mgr Hiredatesal Deptno 7369 Smith Clerk 7902 17 Dec 80800 20 7499 1
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 23 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”