"HR-SQL The Report"의 두 판 사이의 차이

2021년 7월 31일 (토) 10:50 기준 최신판

1 개요[ | ]

HR-SQL The Report

https://www.hackerrank.com/challenges/the-report/problem

해커랭크 SQL
문제	DB2	MS SQL	MySQL	Oracle
HR-SQL Basic Join e
HR-SQL Asian Population
HR-SQL African Cities
HR-SQL Average Population of Each Continent
HR-SQL The Report
HR-SQL Top Competitors
HR-SQL Ollivander's Inventory
HR-SQL Challenges
HR-SQL Contest Leaderboard

2 MySQL[ | ]

SELECT
    CASE WHEN Grade<8 THEN NULL ELSE Name END,
    Grade, Marks
FROM Students AS S
JOIN Grades AS G ON (S.Marks BETWEEN G.Min_Mark AND Max_Mark)
ORDER BY Grade DESC, Name

@@ 8번째 줄: / 8번째 줄: @@
 ==MySQL==
-<source lang='mysql'>
+<syntaxhighlight lang='mysql'>
 SELECT
      CASE WHEN Grade<8 THEN NULL ELSE Name END,
@@ 15번째 줄: / 15번째 줄: @@
 JOIN Grades AS G ON (S.Marks BETWEEN G.Min_Mark AND Max_Mark)
 ORDER BY Grade DESC, Name
-</source>
+</syntaxhighlight>