(10) Using the EMP_2 table, write a single SQL command to change the EMP_PCT values to 5.00 for the people with employee numbers 101, 105, and 107.

 

11. Using the EMP_2 table, write a single SQL command to change the EMP_PCT value to 10.00 for all employees who do not currently have a value for EMP_PCT.

I've tried this code:

UPDATE EMP_2

SET EMP_PCT = 10.00

WHERE EMP_PCT IS NULL;

But it doesn't work. The following results show:

I've tried (10.00), (10), 10.00, 10, '10.00', '10', and I receive the same results.

----------------------------------------------------------------------------------------------------------------------------------------------------

15. Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. When you finish Problems 7–15, the EMP_2 table will contain the data shown in Figure P8.15.

My code:

UPDATE EMP_2

SET PROJ_NUM = 14

WHERE EMP_HIREDATE

AND JOB_CODE >= 501;

Results:

Solve questions 11 and 15.
 

FIGURE P8.1 THE CH08_CONSTRUCTCO DATABASE Relational diagram JOB 500 501 502 503 504 505 506 300 507 508 509 510 JOB CODE JOB DESCRIPTION JOB CHG HOUR JOB LAST UPDATE EMPLOYEE 15 18 22 25 Table name: JOB JOB_CODE JOB_DESCRIPTION JOB CHG HOUR | JOB_LAST_UPDATE 35.75 96.75 125.00 84.50 67.90 55.78 26.87 20.01 Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 45.95 48.10 34.55 18.36 Table name: PROJECT PROJ_NUM PROJ_NAME PROJ_VALUE Evergreen 1453500.00 Amber Wave 3500500.00 Rolling Tide 805000.00 Starflight 2650500.00 ASSIGNMENT Y ASSIGN NUM ASSIGN DATE PROJ_NUM EMP_NUM ASSIGN JOB ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN CHARGE 20-Nov-17 20-Nov-17 24-Mar-18 20-Nov-17 20-Nov-17 -NOV-17 20-Nov-17 -NOV-17 20-Nov-17 20-Nov-17 24-Mar-18 20-Nov-17 20-Nov-17 m PROJ_BALANCE EMP_NUM 1002350.00 103 2110346.00 108 500345.20 102 2309880.00 107 PROJECT PROJ_NUM PROJ_NAME PROJ_VALUE PROJ BALANCE EMP_NUM 1001 1002 1003 1004 1005 4000 1006 1007 1007 1008 1009 1010 1011 Table name: EMPLOYEE 1012 1013 1014 1015 FOX 1016 ADAT 1017 von 1018 P 1019 **** 1020 1021 1022 1023 1024 1025 EMP_NUM EMP_LNAME 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 News John Senior David Arbough June Ramoras Anne Johnson Alice Smithfield William Alonzo Maria Washington Ralph Smith Larry Olenko Gerald Wabash Geoff Smithson Darlene Joenbrood Delbert Jones Annelise Bawangi Travis Pratt Gerald Angie James 23-Mar-18 22 23-Mar-18 15 23-Mar-18 22 communio 23-Mar-18 15 23-Mar-18 25 24-Mar-18 25 24-Mar-18 15 24-Mar-18 22 24-Mar-18 22 24-Mar-18 22 24-Mar-18 15 24-Mar-18 18 103 117 117 103 108 sos 104 112 113 102 103 115 117 105 Williamson Frommer Table name: ASSIGNMENT ASSIGN_NUM ASSIGN_DATE PROJ_NUM EMP_NUM ASSIGN_JOB ASSIGN_CHG_HR ASSIGN HOURS ASSIGN_CHARGE 3.5 4.2 2.0 22-Mar-18 18 22-Mar-18 22 22-Mar-18 18 22-Mar-18 15 22-Mar-18 25 22-Mar-18 22 27 Max 5.9 2.2 13 4.2 22-Mar-18 25 22-Mar-18 18 23-Mar-18 15 23-Mar-18 15 23-Mar-18 25 23-Mar-18 18 23-Mar-18 25 108 115 19 104 103 105 Dek 117 117 104 101 EMP_FNAME 108 115 105 103 117 503 509 509 503 501 501 508 503 502 501 509 502 SUT 501 501 501 201 503 502 - 509 509 501 502 501 501 Database name: Ch08_ConstructCo 502 503 509 EMP INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS G H E K K D B W A M K 8 L H J 84.50 34.55 34.55 84.50 96.75 96.75 50.75 84.50 96.75 34.55 105.00 96.75 96.75 96.75 84.50 ...... 105.00 c 34.55 34.99 34.55 110.50 125.00 110.50 110.50 08-Nov-00 502 12-Jul-89 501 01-Dec-96 500 15-Nov-87 501 01-Feb-93 502 125.00 84.50 34.55 22-Jun-04 500 10-Oct-93 500 22-Aug-91 501 18-Jul-97 501 11-Dec-95 505 04-Apr-91 506 23-Oct-94 507 15-Nov-96 508 20-Aug-93 508 25-Jan-92 501 05-Mar-97 510 19-Jun-96 509 04-Jan-05 510 20 3.8 0.9 56 5.6 24 2.4 4.3 3.4 2.0 2.0 2.8 2.0 6.1 7 4.7 - 3.B 2 2.2 - 4.9 3.1 2.7 4:1 4.9 3.5 3.3 4.2 295.75 145.11 69.10 498.55 212.85 406.35 192.85 76.05 76.05 541.80 82.92 451.50 328.95 193.50 210.90 270.90 515.45 493.50 700.00 131.29 Petite 76.01 541.45 387.50 298.35 541.45 437.50 278.85 145.11 12 23 18 25 19 8 19 21 15 17 21 18 16 19 20 15 16 7