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.
with mycte as
(select id , name , marks , case when
marks between 0 and 9 then 1
when
marks between 10 and 19 then 2
when
marks between 20 and 29 then 3
when
marks between 30 and 39 then 4
when
marks between 40 and 49 then 5
when
marks between 50 and 59 then 6
when
marks between 60 and 69 then 7
when
marks between 70 and 79 then 8
when
marks between 80 and 89 then 9
else 10
end as grade
from students )
select case when grade < 8 then "NULL" else name end as name, grade ,marks from mycte
order by grade desc , name
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 →
sql server solution using cte
with mycte as (select id , name , marks , case when marks between 0 and 9 then 1 when marks between 10 and 19 then 2 when marks between 20 and 29 then 3 when marks between 30 and 39 then 4 when marks between 40 and 49 then 5 when marks between 50 and 59 then 6 when marks between 60 and 69 then 7 when marks between 70 and 79 then 8 when marks between 80 and 89 then 9 else 10 end as grade from students )
select case when grade < 8 then "NULL" else name end as name, grade ,marks from mycte order by grade desc , name