hackerrank case when 문제 풀이

문제

• https://www.hackerrank.com/challenges/what-type-of-triangle/problem?h_r=internal-search
• 요약하면 A,B,C 세 길이가 주어지고, A,B,C 를 각각 판단해서 이름을 alias 붙여주면 됨.

풀이

select
    case
        when (A + B <= C) OR (B+C <= A) OR (C+A <= B) then 'Not A Triangle'
        when A=B and B=C then 'Equilateral'
        when (A=B and B!=C) OR (B=C and C!=A) OR (C=A and A!=B) then 'Isosceles'
        when A!=B and B!=C and C != A then 'Scalene'
    end
from
    TRIANGLES
;