should be included in thé lisulng. SurtticT Complete Problem 1 above. Problem 2

Question

should be included in thé lisulng. SurtticT Complete Problem 1 above. Problem 2 e ENPLOYEE . 508,and PROJECT tables in the Choz ConstructCo database, write the SOL code that will join the 308, ENPLOVEE, and PROJECT tables using common attributes. Display the attributes shown in the results presented in Figure P7.2 sorted by project value. PROI NAM PRO VALUE Peg .BALANCE EMP tNAME EMPFNAME EMP INTIAL JOB. CODE JO.DESCRIPTION JOB CHG.HOUR Evergreen453500.00100235000Arbough june Suarflght 2650500.00 2309880.00 Amber Wave 3500500.00 2110345.00Washington Ralph Systems Analyst9675 Programmer Progammer Marla Complete Problem 2 above. Problem 3 Write the SQL code that will produce the same information that was shown in Prob the employee's last name.

Explanation / Answer

Problem 2 :- we will join PROJECT and EMPLOYEE by EMP_NUM as it is common key in both the tables. and EMPLOYEE and JOB table based on the JOB_CODE which is common in both the tables.

Query for the problem is

Select PROJ_NAME, PROJ_VALUE, PROJ_BALANCE, EMP_LNAME, EMP_FNAME, EMP_INITIAL, JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR,

FROM PROJECT p inner join EMPLOYEE e on

p.EMP_NUM = e.EMP_NUM inner join JOB j on

e.JOB_CODE = j.JOB_CODE

Order By PROJ_VALUE ASC;

Problem 3

Select PROJ_NAME, PROJ_VALUE, PROJ_BALANCE, EMP_LNAME, EMP_FNAME, EMP_INITIAL, JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR,

FROM PROJECT p inner join EMPLOYEE e on

p.EMP_NUM = e.EMP_NUM inner join JOB j on

e.JOB_CODE = j.JOB_CODE

Order By EMP_LNAME ASC;

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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