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;
