HackerRank / Basic Join / The Report / MySQL
2023. 10. 10. 00:08
📚문제 📝풀이 SELECT S.Name , G.Grade , S.Marks FROM STUDENTS S INNER JOIN Grades G ON S.Marks >= G.Min_mark AND S.Marks = 8 ORDER BY G.Grade DESC, S.NAME; SELECT NULL , G.Grade , S.Marks FROM STUDENTS S INNER JOIN Grades G ON S.Marks >= G.Min_mark AND S.Marks = 8 THEN s.Name ELSE NULL END AS Name , g.Grade , s.Marks FROM Students s JOIN Grades g ON s.Marks >= g.Min_Mark AND s.Marks
