Untitled

Select if(Grade>7,Name,NULL),Grade,Marks
From Students,Grades
Where  Min_Mark<=Marks and Max_Mark>=Marks
order by
case when Grade>=1 then Grade end Desc, 
case when Grade <=7 then Marks end,
Name;