16
17 89
Ferris Mcfarland 0
Thaddeus Wilkinson 0
Picture 6.1
Question 7:
Write a query to display, for each enrollment concerning the 'Project management' course,the information of the student who enrolled in the course, the semester that the student enrolled in the course and the average mark of this enrollment. Display the results with enrollmentid, Courseld, title, studentld, StudentName, Semester Code, AverageMark as in the following figure. Note that the AverageMark of an enrollment is calculated based on the mark and the percentage (percent attribute) of each assessment of the course corresponding to the enrollment. For example, a course has 2 assessments x1 and x2 and the percentage of these two assessments are respectively 0.4 and 0.6. If a student enrolled in this course in the 'Sp2019' semester and having the mark 5 for x1 and the mark 6 for x2,then the average mark in 'Sp2019' of the student for this course is calculated as 5*0.4 + 6*0.6 5.6. Display the results in ascending order of studentld, then in ascending order of SemesterCode for rows of the same student.
Zoom
+ 100%
Close
