**SELECT
CASE WHEN G.Grade >=8 then S.Name ELSE null END , G.Grade, S.Marks FROM Students as S INNER JOIN Grades as G on S.Marks BETWEEN G.Min_Mark AND G.Max_Mark order by G.Grade desc , S.Name Asc ; **

thank me later : SELECT CASE WHEN Grade < 8 THEN NULL ELSE Name END AS Name , Grade , Marks FROM Students JOIN Grades ON Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark ORDER BY Grade DESC, ( CASE WHEN Grade < 8 THEN Marks ELSE Name END ) ASC

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;

SET NOCOUNT ON;

SELECT CASE WHEN g.Grade < 8 THEN 'NULL' ELSE s.Name END AS Name, 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 NULL END asc, CASE WHEN g.Grade < 8 THEN s.marks ELSE NULL END asc; go

Since there's no ID to join the tables directly, we’re using Marks to join the table and match each student to a grade range. See line: ON Students.Marks BETWEEN Grades.MinMark AND Grades.MaxMark. I used to think you could only join tables using IDs, but this example shows you can also join using value-based conditions, like a range. Thought this might help others who are new to SQL like myself!

SELECT IF(Grades.Grade < 8, NULL, Students.Name) AS Name, Grades.Grade, Students.Marks FROM Students JOIN Grades ON Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark ORDER BY Grades.Grade DESC, Students.Name, Students.Marks;