Example 5.18.6 To compute the evolution of the grade average for each stu-
dent as he or she advances towards graduation, we can write a query that returns
the cumulative average for each student for the sequence of semesters when the
student is active: