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.
----if someone finds a mistake in this please comment
Select
CASE
When grades >= 8 Then name
Else
NULL
End As name ,
grades,
marks_secured
From
(Select
s.name As Name,
g.grade as Grades,
s.marks As marks_secured
From Students s
Left Join Grades g
ON
s. marks between g.min_mark And g.max_mark) As rep
Order by
grades 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 →
----if someone finds a mistake in this please comment Select CASE When grades >= 8 Then name Else NULL End As name , grades, marks_secured From
(Select s.name As Name, g.grade as Grades, s.marks As marks_secured From Students s Left Join Grades g ON s. marks between g.min_mark And g.max_mark) As rep Order by grades DESC , name;