I would like to create an average of grades per quarter for each student
|Student table--related to grade table||Grade Table|
There are 4 quarters each year
What would be the best way to calculate the average grades per quarter?
I am able to create the average of all the grades.
(Maybe I need to redesign the grade table?)