Example 5.18.6 To compute the evolution of the grade average for each student 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: