HackerRank MySQL - The Report




You are given two tables: Students and Grades. Students contains three columns ID, Name and Marks.



  1. SELECT CASE
  2. WHEN G.GRADE < 8 THEN NULL
  3. ELSE S.NAME
  4. END AS NAME,
  5. G.GRADE,
  6. S.MARKS
  7. FROM STUDENTS S
  8. INNER JOIN GRADES G ON S.MARKS BETWEEN G.MIN_MARK AND G.MAX_MARK
  9. ORDER BY G.GRADE DESC,
  10. NAME,
  11. MARKS;




codesadda.com

Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.

Like us on Facebook | Connect with us on LinkedIn | Subscribe our Channel on Youtube