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 Points < 8 THEN NULL
ELSE Name
END, Points, Marks
FROM (SELECT Name,
CASE
WHEN Marks >=90 THEN 10
WHEN Marks >=80 THEN 9
WHEN Marks >=70 THEN 8
WHEN Marks >=60 THEN 7
WHEN Marks >=50 THEN 6
WHEN Marks >=40 THEN 5
WHEN Marks >=30 THEN 4
WHEN Marks >=20 THEN 3
WHEN Marks >=10 THEN 2
WHEN Marks >=0 THEN 1
END AS Points, Marks
FROM Students )AS t
ORDER BY Points DESC, 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 Points < 8 THEN NULL ELSE Name END, Points, Marks FROM (SELECT Name, CASE WHEN Marks >=90 THEN 10 WHEN Marks >=80 THEN 9 WHEN Marks >=70 THEN 8 WHEN Marks >=60 THEN 7 WHEN Marks >=50 THEN 6 WHEN Marks >=40 THEN 5 WHEN Marks >=30 THEN 4 WHEN Marks >=20 THEN 3 WHEN Marks >=10 THEN 2 WHEN Marks >=0 THEN 1 END AS Points, Marks FROM Students )AS t ORDER BY Points DESC, Name ASC;