1
2
3
4
5
6
7
8
|
select
case when g.grade >=8 then s.name else null end,
g.grade,
s.marks
from students s join grades g
on s.marks between g.min_mark and g.max_mark
where s.marks > 8
order by g.grade desc, s.name, s.marks;
|
cs |
반응형
'SQL' 카테고리의 다른 글
leetcode 1741. Find Total Time Spent by Each Employee (0) | 2022.03.29 |
---|---|
leetcode 1757. Recyclable and Low Fat Products (0) | 2022.03.29 |
Hacker Rank Top Competitors (0) | 2022.03.29 |
Hacker rank Weather Observation Station 20 (0) | 2022.03.29 |
hacker rank Weather Observation Station 19 (0) | 2022.03.29 |
댓글