1.Create a query to display the number of students who were enrolled in workshops in all sessions for 2019. The result should include the session, unit code, unit name, campus location, tutor name and the total count of students enrolled. The result should be sorted by the Session, unit code, campus location and workshop day & time.

O spun 11 A2 COURSE CourseCode : int(7) unsigned CourseName : varchar(200) # CreditPoints : int(3) Notes : varchar(300) v spun 11A2 COURSE_ENROLMENT StudentID : int(11) unsigned Course Code : int(7) unsigned EnrolmentDate : date Status : varchar(20) spun 11 A2 STUDENT StudentID : int(11) unsigned FirstName : varchar(30) LastName : varchar(30) Address : varchar(100) City : varchar(30) State: varchar(30) Postcode : varchar(6) Phone : varchar(12) Email : varchar(100) spun 11A2 UNIT spun 11A2 UNIT_ENROLMENT UnitEnrolmentID : varchar(7) # StudentID : int(11) unsigned @ UnitOfferingID : varchar(8) # Year : int(4) # Session : int(1) EnrolmentType : varchar(40) FinalGrade : varchar(20) spun 11 A2 UNIT OFFERING UnitOfferingID : varchar(8) UnitCode : varchar(11) # Year : int(4) # Session : int(1) UnitAssessorID : varchar(8) e Locations : varchar(40) UnitCode : varchar(11) UnitName : varchar(200) Prerequisities : varchar(100) Description : varchar(300) v spun 11 A2 WORKSHOP_ENROLMENT WorkshopID : int(7) unsigned StudentID : int(11) unsigned v o spun 11 A2 UNIT_ASSESSOR UnitAssessorID : varchar(8) StaffID : int(6) unsigned o spun 11 A2 STAFF StaffID : int(6) unsigned @ FirstName : varchar(30) LastName : varchar(30) Campus : varchar(20) Office Location : varchar(30) @ Email : varchar(100) Phone : varchar(12) o spun 11 A2. WORKSHOP WorkshopID : int(7) unsigned UnitOfferingID : varchar(8) Campus : varchar(30) Location : varchar(100) TeacherID : varchar(8) Weekday : varchar(30) Class Times : time spun 11A2.TEACHER TeacherID : varchar(8) Staffit : int(6) unsigned spun 11 A2 STUDENT_ASSESSMENT AssessmentID : varchar(7) StudentID : int(11) unsigned Date Submitted : date # DaysExtension : int(2) # MarkAwarded : int(2) spun 11 A2 ASSESSMENT AssessmentID : varchar(7) UnitOfferingID : varchar(8) AssessmentName : varchar(30) Description : varchar(80) DueDate : date # PossibleMarks : int(2)