Now create and run a sql query that displays only employee name (first name, middle initial, and last name) and job description sorted by employee last name. see the picture below for the expected result. note to accomplish this you must use concat() function and alias to get employee name grouped into one attribute named emp_name along with sorting the data prior to display. see lecture slide 71 for concat and alias and lecture slides 89 & 90 for sorting a list. additionally you will need to join emp_1 with job by job_code but only select job description to be displayed besides the employee’s name. see lecture slides 100-104 and the textbook for details.

Acommercial grade cubical freezer, 4 m on a side, has a composite wall consisting of an exterior sheet of 5.0-mm thick plain carbon steel (kst= 60.5 w/m k), an intermediate layer of 100-mm thick polyurethane insulation (kins 0.02 w/m k), and an inner sheet of 5.0- mm thick aluminium alloy (kal polyurethane insulation and both metallic sheets are each characterized by a thermal contact resistance of r 2.5 x 104 m2 k/w. (a) what is the steady-state cooling load that must be maintained by the refrigerator under conditions for which the outer and inner surface temperatures are 25°c and -5°c, respectively? (b) for power saving purpose, which wall material should be increased/reduced in. thickness in order to reduce 50% of the cooling load found in part (a)? redesign the thickness of the proposed material. 177 w/m-k). adhesive interfaces between the q=575.93 w