Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code that...

  

Transcribed Image Text:

Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP NUM as the common attribute. Display the attributes shown in the results presented in Figure P7.2, sorted by project value. FIGURE P7.2 THE QUERY RESULTS FOR PROBLEM 2 PROJ NAME Roing Te Evergraan Startight Amber Veve PROJ VALUE FRO BALANCE BXP_LNAME BP FNAME EMP_NTIAL DE_CODE JOB_DESCRPTION JOE_CHO_HOLR BOS000.00 1453500 00 2650500 00 3500500.00 500345.20 Servor David 501 Systems Aralyst Programmer 96.75 1002350.00 bough 23333D00 Alnzo 2110048.00 ashington 500 35.75 kerin S00 Progranmer 五75 Raluh 501 Systems Aralyst 90.75 Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code that will join the EMPLOYEE and PROJECT tables using EMP NUM as the common attribute. Display the attributes shown in the results presented in Figure P7.2, sorted by project value. FIGURE P7.2 THE QUERY RESULTS FOR PROBLEM 2 PROJ NAME Roing Te Evergraan Startight Amber Veve PROJ VALUE FRO BALANCE BXP_LNAME BP FNAME EMP_NTIAL DE_CODE JOB_DESCRPTION JOE_CHO_HOLR BOS000.00 1453500 00 2650500 00 3500500.00 500345.20 Servor David 501 Systems Aralyst Programmer 96.75 1002350.00 bough 23333D00 Alnzo 2110048.00 ashington 500 35.75 kerin S00 Progranmer 五75 Raluh 501 Systems Aralyst 90.75

Answer rating: 100% (QA)

Answer The sql query to execute the following table fro... View the full answer