Here below is a data table:

Sort the data (in ascending order) by Class, (in descending order) by Score:

=spl("=E(?1).sort(Class,Maths:-1)",A1:C12)