Question

Problem 3 Write the SQL code that will produce the same information that was shown in Problem 2, but sorted by the employee's last name. The results of running that query are shown in Figure P7.3. PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_LNAME EMP_FNAME EMP_INITIAL JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR Starflight 2650500.00 2309880.00 Alonzo Maria D 500 Programmer 35.75 Evergreen 1453500.00 1002350.00 Arbough June E 500 Programmer 35.75 Rolling Tide 805000.00 500345.20 Senior David H 501 Systems Analyst 96.75 Amber Wave 3500500.00 2110346.00 Washington Ralph B 501 Systems Analyst 96.75 Complete Problem 3 above. Figure P7.3 Task Problem 4 Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number. The results of running that query are shown in Figure P7.4. PROJ_NUM 15 18 22 25 Figure P7.4 Task Complete Problem 4 above. Problem 5

          Problem 3
Write the SQL code that will produce the same information that was shown in Problem 2, but
sorted by the employee's last name. The results of running that query are shown in Figure P7.3.
PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_LNAME EMP_FNAME EMP_INITIAL JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR
Starflight 2650500.00 2309880.00 Alonzo Maria D 500 Programmer 35.75
Evergreen 1453500.00 1002350.00 Arbough June E 500 Programmer 35.75
Rolling Tide 805000.00 500345.20 Senior David H 501 Systems Analyst 96.75
Amber Wave 3500500.00 2110346.00 Washington Ralph B 501 Systems Analyst 96.75
Complete Problem 3 above.
Figure P7.3
Task
Problem 4
Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table,
sorted by project number. The results of running that query are shown in Figure P7.4.
PROJ_NUM
15
18
22
25
Figure P7.4
Task
Complete Problem 4 above.
Problem 5

Problem 3
Write the SQL code that will produce the same information that was shown in Problem 2, but
sorted by the employee's last name. The results of running that query are shown in Figure P7.3.
PROJNAME PROJVALUE PROJBALANCE EMPLNAME EMPFNAME EMPINITIAL JOBCODE JOBDESCRIPTION JOBCHGHOUR
Starflight 2650500.00 2309880.00 Alonzo Maria D 500 Programmer 35.75
Evergreen 1453500.00 1002350.00 Arbough June E 500 Programmer 35.75
Rolling Tide 805000.00 500345.20 Senior David H 501 Systems Analyst 96.75
Amber Wave 3500500.00 2110346.00 Washington Ralph B 501 Systems Analyst 96.75
Complete Problem 3 above.
Figure P7.3
Task
Problem 4
Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table,
sorted by project number. The results of running that query are shown in Figure P7.4.
PROJNUM
15
18
22
25
Figure P7.4
Task
Complete Problem 4 above.
Problem 5

Added by Matthew W.

Question

Please give Ace some feedback