# Type of Triangle
select case when((A >= B+C) or (B >= A+C) or (C >= A+B)) then 'Not A Triangle'
when(A = B and A = C) then 'Equilateral'
when(A != B and A != C and B!=C) then 'Scalene'
else 'Isosceles'
end
from TRIANGLES;
'코딩 연습 > SQL' 카테고리의 다른 글
[Hacker Rank] Revising Aggregations1 (0) | 2021.04.04 |
---|---|
[Hacker Rank] Occupations (0) | 2021.04.04 |
[HackerRank] The PADS (0) | 2021.04.04 |
[HackerRank] Basic Select2 (마무리) (0) | 2021.04.02 |
[HackerRank] Weather Observation Station 시리즈 뒷부분 (0) | 2021.04.02 |