I\'m really behind and I need all the help I can get. Please assign one of your
ID: 3622322 • Letter: I
Question
I'm really behind and I need all the help I can get. Please assign one of your great experts on this: Thanks for all of the great work you doNote: Question 7 9, 10, 12.13 and 14 have been answered
Unit 4 Assignment 1
Directions
Perform the following tasks below by using the correct SQL statements. Create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into this assignment document. Upload this Word document for grading.
All questions should be answered with one SQL statement
1. Change the department number of all employees with employee 7900’s job title to employee 7900’s current department number. (use the emp table)
2. Generate a listing showing the ename, salary, and department number for all employees that have the same title as the employee Adams. (Use the emp table).
3. Create a new table spec_emp that includes the ename, job, mgr, hiredate, sal, and comm columns from the emp table. Include only those employees that have the same hiredate as James.
4. Insert into the spec_emp table all the employees that work in the same department as Jones. (Use the emp table )
5. Delete the information from the spec_emp table for all employees who have the same job as Smith. (Use the emp table )
6. Display the employee number and name for each employee who job is not the same as that of any employee named Smith or Scott. (Use the emp table)
8. Find all the employees who have a higher credit limit than the average credit limit of their particular department. Show employee_id, first_name, last_name, credit_limit, and dept_code in your results. (l_employees table)
11. Using the l_employees table, create a query that shows the management hierarchy. Structure the query so that it will always start with the employee who does not have a manager. Show employee_id, first_name, last_name in your results. Pad the results so that each successive level is indented.
Explanation / Answer
Dear, 8. Find all the employees who have a higher credit limit than the average credit limit of their particular department. Show employee_id, first_name, last_name, credit_limit, and dept_code in your results. (l_employees table) SELECT EMPLOYEE_ID,FIRST_NAME,LAST_NAME,CREDITLIMIT FROM L_EMPLOYEE WHERE CREDITLIMIT > (SELECT AVG(CREDITLIMIT) FROM L_EMPLOYEE ) 11. Using the l_employees table, create a query that shows the management hierarchy. Structure the query so that it will always start with the employee who does not have a manager. Show employee_id, first_name, last_name in your results. Pad the results so that each successive level is indented. SELECT EMPLOYEEID,FIRST_NAME,LAST_NAME FROM L_EMPLOYEE ORDER BY AESC MANAGERID we don't have the data base of emp table, if you can provide will answer remaining