Thank you very much in advance for your help!!!! Unit 4 Assignment 1 Directions

Question

Thank you very much in advance for your help!!!!
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

4. Insert into the spec_emp table all the employees that work in the same department as Jones. (Use the emp table )

9. Find all employees who make less than the average salary. Show emp, ename, sal in your results. (emp table)

Column Name Data Type Nullable Default Primary Key
EMPNO NUMBER(4,0) No - 1
ENAME VARCHAR2(10) No - -
JOB VARCHAR2(9) Yes - -
MGR NUMBER(4,0) Yes - -
HIREDATE DATE Yes - -
SAL NUMBER(7,2) Yes - -
COMM NUMBER(7,2) Yes - -
DEPTNO NUMBER(2,0) Yes - -
1 - 8

Explanation / Answer

SQL> create view l_suppliers_view as select supplier_id,supplier_name,SUBSTR(supplier_name, 1, 1) as abrv_nm from l_suppliers; SQL> SELECT supplier_id FROM l_foods WHERE Price>(SELECT AVG(Price) FROM l_foods ); 10.SQL> SELECT empno,ename,deptno,MAX(salary) as salary FROM employees GROUP BY deptno;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.