You are viewing a single comment's thread. Return to all comments →
If the grade of two students are less than 8 and they are equal (like if A got 55 and B got 58, both recieve the same grade 6) then list them in increasing order of their marks.
NULL 6 55 (record of A) followed by NULL 6 58 (record of B)
So first order by grade in descending order, then by marks in ascending order if grade is less than 8.
Otherwise order by grade in descending order, and name in acending order if grade is >= 8