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 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 ;
**
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 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 ; **