don't get confuse if you don't see an 'asc' keyword in many above soln. here r 2 query both identical and do same work

select (case when g.grade > 7 then s.name else Null end), g.grade, s.marks from students s, grades g where s.marks between g.min_mark and g.max_mark order by g.grade desc, s.name, s.marks asc

select (case when g.grade > 7 then s.name else Null end), g.grade, s.marks from students s, grades g where s.marks between g.min_mark and g.max_mark order by g.grade desc, s.name, s.marks