The attributes of my table are the following
Year Student name Grade in Geography Grade in history etc.
I would like to calculate the average grade and standard deviation for each of my students in each subject on several years. I though that the PIVOT operator was the right one for that. But whatever the weight aggregation (sum, standard deviation) I always obtain the highest grade for each student, not the average one or the standard deviation.
Could you help ?