1. Write the query in SQL to show the employee name with the most assigned hours

2. Write the query in SQL to show the most expensive project.

FIGURE P7.1 THE CHO7_CONSTRUCTCO DATABASE Database name: Ch07_ConstructCo Relational diagram RONMENT LOVE ram Dewi Ho the Last Up A Emo Frame www Won Table name: JOB Ice COC JO DECORATION 2000 MOR 100 LAST UPDATE Page 3575 2017 SAW 9675 2017 09 D Deger 20.10 Dergine 450 04 Mechanical Engineer 2017 Cul Engineer 900 Cluiceport 25 30.11 DSS Ant 56 20 Maw17 Alone Designer 6510 2.18 Bo Technici 34.55 2017 510 OS 16.30 Table name: EMPLOYEE EMP MUMEMPUNAME EMP FRAME EMP_NITIAL EMPHIREDATE 208_CODE EMP YEARS 101 News John 08-Nov-00 502 17 102 Senior David 12-01-09 501 20 103 Abough une E 01 Dec 06 400 21 PORCE 104 Ramos 15. No.87 501 105 Johnson Alice K 01 Feb-99 500 105 Smi 22-Jun-04 500 13 Pre Value 107 Alonso Maria D 100d-99 100 24 PI 100 Washington Rakh 22-Aug-91 01 109 LITY w 16 AG 501 20 110 Olero Geral A 11-Dec-95 505 lebah Onoft D 04-Apr-21 905 27 112 Smithson Dar M 230d-94 507 23 113 Joenrood Debert K 15-Nov-95 500 21 116 Jones Amelie 20-Aug-2500 115 Bowing Traves B 25-2 501 115 Pro Gerald L 05 Mar-97 510 117 Angie 19-Jun-96 500 118 From James 04-05 510 Table name: ASSIGNMENT ASSIGNUMASSION DATE PORUMB JUMASINASSONO PASSIONHOURS ASIGN OURCE JOURS 1001 22-1010 09 300 05 29578 1002 22.MM.1 22 113 900 3455 42 10511 1003 1615 111 35 2 01 1004 20-110 100 22.12 901 9.15 212 1000 22-182 104 301 0033 1007 23.12 3 TRON 1000 22.11a 500 005 76 DS 1000 23.10.15 115 501 55 5418 100 23.115 117 SOS 24 90 1011 23.10.20 05 300 105 515 1013 21.18 901 34 00 2018 301 2 1995 1014 23.1 22 501 28 2709 1015 23.10.15 NO 500 45 515.45 10 23.12 00 so 105 43 1017 23.10.10 113 50 3.55 13129 109 117 90 22 701 10 22. 104 601 05 54145 1000 2:18 15 1 503 3.1 5 1021 2018 22 501 9105 23 1002 2.1 22 016 001 MIDS 54145 100 2.10 22 SO 125 35 4375 1004 2-16 303 145 33 1024 ca.10 18 012 BOB 345 42 . Table name: PROJECT PROHNUNG PROJ. NAME ROL VALLE PROU. BALANCE EMNOJM 15 10000 1002350 DO 103 10 Ambe wa 360000000 2110300 100 22 Rating Tide BO5000.00 500345 20.102 25 266000000 20000000 100