반응형
https://www.hackerrank.com/challenges/the-report/problem?h_r=internal-search&isFullScreen=true
The Report | HackerRank
Write a query to generate a report containing three columns: Name, Grade and Mark.
www.hackerrank.com
JOIN ON BETWEEN
join 절에 다음과 같이 between을 사용 할 수 있다.
SELECT IF(G.GRADE >= 8, S.NAME, NULL), G.GRADE, S.MARKS
FROM STUDENTS S
JOIN GRADES G ON S.MARKS BETWEEN G.MIN_MARK AND G.MAX_MARK
ORDER BY G.GRADE DESC, S.NAME반응형
'IT study > SQL' 카테고리의 다른 글
| LeetCode : 185. Department Top Three Salaries (0) | 2021.10.22 |
|---|---|
| Leetcode : 180. Consecutive Numbers (0) | 2021.10.22 |
| HackerRank : Challenges (0) | 2021.10.22 |
| LeetCode : 184. Department Highest Salary (0) | 2021.10.21 |
| Challenges (0) | 2021.05.02 |