I'm trying to think about the best way to do this. If i have a table like this in sql server:
I need to have Averages and standard deviation calculated as well for a student. I know i can create a view, or create a new table with these computed columns, or add the computed columns to this table.
Not sure if there are any other options but in terms of performance, what would be the best way to do this?