2017-04-07 20:17:38 -05:00
|
|
|
-- Author: Rodney Shaghoulian
|
2018-07-27 16:45:56 -07:00
|
|
|
-- Github: github.com/RodneyShag
|
|
|
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
2017-04-07 20:17:38 -05:00
|
|
|
|
|
|
|
|
SELECT IF (S.Marks < 70, 'NULL', S.Name), G.Grade, S.Marks
|
|
|
|
|
FROM Students AS S, Grades AS G
|
|
|
|
|
WHERE S.Marks BETWEEN G.Min_Mark AND G.Max_Mark
|
|
|
|
|
ORDER BY G.GRADE DESC, S.NAME;
|
