Answered>Order 7530

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;