How to apply aggregate function on Latest/ Last Updated Entry of a table
I have a table that stores semester GPA and Cumulative GPA of a student. After every semester an entry of semester GPA and updated Cumulative GPA is added in that table. So if a student has completed five semesters then there will be 5 entries in that table.
I need to get latest semester GPA and Cumulative GPA of all students and then want to get their AVG, MAX, MIN, STDEV. Can someone help?
I do not have a date field in this table but I have fields of term. An entry is added in the table against a term.