Answered You can hire a professional tutor to get the answer.

QUESTION

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;

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question