1. Create a query to display the total marks for each students assessments in all sessions for 2019. The result should include the student names, unit code, the sum of marks given for their assessments and the final grade given. It should be sorted by the students last name and first name, session, and unit code. Note: the final grade is entered by the unit assessor into the database, not calculated automatically from the total.

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)