1. Create a query to display the information required for a Student Transcript. The result should include the student number, student name, year, session, unit

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)