really need the output Run the lab_03_01.sql script in the lab folder to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY… | Cheap Nursing Papers

really need the output Run the lab_03_01.sql script in the lab folder to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY…

really need the output

Run the lab_03_01.sql script in the lab folder to create the SAL_HISTORY table. 2. Display the structure of the SAL_HISTORY table. DESC sal_history 3. Run the lab_03_03.sql script in the lab folder to create the MGR_HISTORY table. 4. Display the structure of the MGR_HISTORY table. DESC mgr_history 5. Run the lab_03_05.sql script in the lab folder to create the SPECIAL_SAL table. 6. Display the structure of the SPECIAL_SAL table. DESC special_sal 7. a. query to do the following: – Retrieve the employee ID, hire date, salary, and manager ID of those employees whose employee ID is less than 125 from the EMPLOYEES table. – If the salary is more than $20,000, insert the employee ID and salary into the SPECIAL_SAL table. – Insert the employee ID, hire date, and salary into the SAL_HISTORY table. – Insert the employee ID, manager ID, and salary into the MGR_HISTORY table. INSERT ALL WHEN SAL > 20000 THEN INTO special_sal VALUES (EMPID, SAL) ELSE INTO sal_history VALUES(EMPID,HIREDATE,SAL) INTO mgr_history VALUES(EMPID,MGR,SAL) SELECT employee_id EMPID, hire_date HIREDATE, Practice 3: Solutions (continued) Oracle Database 10g: SQL Fundamentals II A – 12 salary SAL, manager_id MGR FROM employees WHERE employee_id < 125;

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp