Question: I need this in SQL, please Lab Exercise Consider the following emp table given below and perform the given below operations. SAL COM 1600 1250
I need this in SQL, please

Lab Exercise Consider the following emp table given below and perform the given below operations. SAL COM 1600 1250 + Oracle SQL Plus Ele Edt Search Options Help SQL> select from emp: EHPAD ENAME JOB 7369 SMITH CLERK 7499 ALLEM SALESHON 7521 WARD SALESMAN 7566 JONES MANAGER 765 HARTIN SALESHAN 7698 BLAKE MANAGER 7782 CLARK HAGER 7788 SCOTT AHALYST 7839 KING PRESIDENT 7 TURIER SALESHAN 7876 ADAMS CLERK 7900 JAMES CLERK 7902 FORD ALYST 7934 MILLER CLERK 14 rows selected. SQL>! MGR HIREDATE 7982 17-DEC-80 7698 20-FEB-81 7698 22-FEB-81 7839 12-APR-81 7699 2R-SEP-81 78-39 01-MAY-81 7839 09-JUN-81 7566 19-APR-27 17-HOU-81 7608 OR-SEP-91 7788 23-HAY-87 7698 03-DEC-81 7566 03-DEC-81 7782 23-JAN-82 2975 1250 2858 2450 3000 5000 1500 1100 950 3000 1300 data 1. Create the emp table and insert the date as showed in the picture. (EMPNO is PK) 2. Rename JOB column with Title. 3. Add a column and name it as Date of Birth 4. Drop the COMM column 5. Rename the table as Employees. 6. Check that the SAL column value is between 500 and 10000 7. Delete all records from the table. - For each step screenshot the SQL code you wrote + screenshot the table showing the changes done. - Upload your work to Blackboard as a PDF file
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
