D2L Page 3 of 2 Use the following tables to assist you with questions 4-6. USERS Userld FirstName John Graham Francois Danika Jennifer Erin Caleb LastName Green Dale-Jones Peters Snow Booth Harvey Jackson Email John.green@school.com Graham.jones@school.com Francois.peters@school.com Danika.snow@school.com Jennifer.booth@school.com Erin.harvey@school.com Caleb.jackson@school.com 4 5 COURSES Courseld CourseCode Course Name Instructor StartDate EndDate ACT102 Accounting 102 Martha Nesbitt 04-14 07-30 FRE101 French 101 Pierre Charette 01-08 03-30 FRE102 French 102 Pierre Charette 04-14 07-30 MUS101 Music 101 Allan Touring 01-08 03-30 ENROLLMENTS Enrollmentld Userld Courseld 12 4 16 3 13 17 15 4. Using the tables above, write a query to identify the first name and last name of all users enrolled in more than one class. 5. Write a query to modify user 6's Last Name to add a hyphenated second name 'Booth' D2L Page 4 of 2 6. You receive a case on January 5 (01-05) from Instructor Pierre Charette, who indicates that a student is missing from his French 101 course. The student is Caleb Jackson. Pierre is requesting that you locate any issues and correct them ASAP as his course is starting in just 3 days. a) Using the tables above, detail your investigation, and all T-SQL statements used to determine the issue. b) Write an update to Pierre explaining the issue and your proposed solution