SELECT
case 
when g.grade >= 8 then s.name end
, g.grade , s.marks
FROM students s
JOIN grades g
ON s.marks BETWEEN g.min_mark and g.max_mark
order by g.grade desc
, case
when g.grade >= 8 then s.name 
else s.marks end;