We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Select CASE WHEN tbl1.Marks >= 70 THEN NAME ELSE 'NULL' END , tbl2.Grade , tbl1.Marks
From Students tbl1
Left Join Grades tbl2
On tbl1.marks Between tbl2.Min_Mark AND tbl2.MAX_MArk
Order By tbl2.grade DESC, tbl1.name ASC;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
Select CASE WHEN tbl1.Marks >= 70 THEN NAME ELSE 'NULL' END , tbl2.Grade , tbl1.Marks From Students tbl1 Left Join Grades tbl2 On tbl1.marks Between tbl2.Min_Mark AND tbl2.MAX_MArk Order By tbl2.grade DESC, tbl1.name ASC;