Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EMPLOYEE table into the EMP_1 table. Remember, your subquery should only retrieve the columns needed for the EMP_1 table and only the employees shown in the figure.

FIGURE P8.1 THE CH08_CONSTRUCTCO DATABASE Database name: Ch08_ConstructCo Relational diagram Table name: EMPLOYEE 00 Alice -- JOB ASSIGNMENT JOB_CODE Y ASSIGN_NUM JOB DESCRIPTION ASSIGN_DATE JOB CHG_HOUR PROJ_NUM JOB_LAST_UPDATE EMP_NUM ASSIGNUJOB ASSIGN_CHG_HR ASSIGN_HOURS EMPLOYEE ASSIGN_CHARGE EMP_NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB CODE EMP_YEARS Table name: JOB JOB_CODE JOB_DESCRIPTION JOB_CHG_HOUR JOB_LAST_UPDATE 500 Programmer 35.75 20-Nov-17 501 Systems Analyst 96.75 20-Nov-17 502 Database Designer 125.00 24-Mar-18 503 Electrical Engineer 84.50 504 Mechanical Engineer 67.90 20-Nov-17 NOV-17 505 Civil Engineer 100 55.78 20-Nov-17 506 Clerical Support 26.87 00 20-Nov-17 20.01 20-NOV- 507 DSS Analyst 45.95 20-Nov-17 508 Applications Designer 48.10 24-Mar-18 509 Bio Technician 34.55 20-Nov-17 510 General Support 18.36 20-Nov-17 00 Travis EMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS 101 News John G 08-Nov-00 502 12 102 Senior David H 12-Jul-89 501 23 103 Arbough June E 01-Dec-96 500 18 104 Ramoras Anne K 15-Nov-87 501 25 105 Johnson K 01-Feb-93 502 19 PROJECT 106 Smithfield William 22-Jun-04 500 8 Y PROJ_NUM 107 Alonzo Maria D 10-Oct-93 500 19 PROJ_NAME PROJ_VALUE 108 Washington Ralph B 22-Aug-91 501 21 PROJ_BALANCE 109 Smith Larry w 18-Jul-97 501 15 EMP_NUM 110 Olenko Gerald 11-Dec-95 505 17 111 Wabash Geoff 04-Apr-91 506 21 112 Smithson Darlene M 23-Oct-94 507 18 113 Joenbrood Delbert K 15-Nov-96 508 16 114 Jones Annelise 20-Aug-93 508 19 115 Bawangi B 25-Jan-92 501 20 116 Pratt Gerald L 05-Mar-97 510 15 117 Williamson Angie H 19-Jun-96 509 16 118 Frommer James J 04-Jan-05 510 7 Table name: ASSIGNMENT ASSIGN_NUM ASSIGN_DATE PROJ_NUM EMP_NUM ASSIGN_JOB ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN_CHARGE 1001 22-Mar-18 18 103 503 84.50 3.5 295.75 1002 22-Mar-18 22 117 509 34.55 4.2 145.11 1003 22-Mar-18 18 117 509 34.55 2.0 69.10 1004 22-Mar-18 18 103 SO3 84.50 5.9 498.55 1005 22-Mar-18 25 108 501 96.75 2.2 212.85 4000 200 1006 22-Mar-10 22 104 501 96.75 4.2 406.35 1007 42 co CO E 22-Mar-18 25 10 OC 1007 20 113 508 50.75 3.B 192.85 102 1008 22-Mar-18 1B -- 103 503 502 84.50 76.05 1009 23-Mar-18 15 115 501 96.75 58 5.6 541.80 1010 23-Mar-18 15 117 21 117 509 34.55 2.4 82.92 1011 23-Mar-18 25 105 - Tom 502 43 TUS 105.00 4.5 451.50 1012 23-Mar-18 18 TUT2 108 501 OUT 96.75 3.4 328.95 1013 23-Mar-18 25 115 501 96.75 2.0 193.50 To 20! Wou 2.0 T. 23-Mar-18 22 104 TO 501 0! 96.75 2.B 270.90 1015 23-Mar-18 15 103 503 84.50 6.1 515.45 one 1016 23-Mar-18 22 105 502 105.00 4.7 493.50 "w.co Tod.de 1017 23-Mar-18 18 117 SOS 34.55 3.B 131.29 1018 23-Mar-18 25 117 509 34.55 2.2 76.01 1019 24-Mar-10 25 104 501 110.50 4.9 541.45 2000 1020 24-Mar-18 15 101 502 125.00 3.1 387.50 1021 24-Mar-18 22 108 501 110.50 2.7 298 35 1022 24-Mar-18 22 115 501 110.50 4.9 541.45 1023 24-Mar-18 22 105 502 125.00 3.5 437.50 1024 24-Mar-18 15 103 503 84.50 3.3 278.85 1025 24-Mar-18 18 117 509 34.55 4.2 145.11 Table name: PROJECT PROJ_NUM PROJ_NAME PROJ_VALUE PROJ_BALANCE EMP_NUM 15 Evergreen 1453500.00 1002350.00 103 18 Amber Wave 3500500.00 2110346.00 108 22 Rolling Tide 805000.00 500345.20 102 25 Starflight 2650500.00 2309880.00 107 1014