"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

@@ 1번째 줄: / 1번째 줄: @@
 ==개요==
 ;HR-SQL The Report
-*
+* https://www.hackerrank.com/challenges/the-report/problem
 {{HR-SQL 헤더}}
@@ 7번째 줄: / 7번째 줄: @@
 |}
-<source lang='sql'>
+==MySQL==
-</source>
+<syntaxhighlight lang='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
+</syntaxhighlight>