. Suppose that the data in the Lecturer and ModuleDelivery tables is as shown below: Lecturer Module Delivery LECTURERID LASTNAME EMAIL FIRSTNAME SALARY BONUS LECTURERNO MODULECODE 101 Byrne pb@techu.com Pat 75000 (null) 101 P101 102 Smith ss@techu.com Sam 89000 7000 101 D102 103 Dillon ad@techu.com Andrew 70000 7000 102 D102 102 P101 102 L103 (a) Using UNION Write the SQL to create the following output: FIRSTNAME LASTNAME TEACHING Pat Byrne is teaching databases Sam Smith is teaching databases Sam Smith is teaching legal issues Hint: You need to join moduledelivery to one other table and to ensure that 'is teaching databases' is output for the Teaching column if the module code is 'D102' and 'is teaching legal issues' is output if module code is 'L103'. You are only interested in including lecturers teaching these modules in the output