[MySQL/CASE문] HackerRank Type of Triangle

1. 문제

https://www.hackerrank.com/challenges/what-type-of-triangle/problem?isFullScreen=true 

Type of Triangle | HackerRank

 

2. 풀이

• case문을 사용해 삼각형의 조건을 확인한다.

 

3. 코드

select case
        when (a = b and b = c) then 'Equilateral'
        when (a + b <= c or  a + c <= b or b + c <= a) then 'Not A Triangle'
        when (a = b or b = c or c = a) then 'Isosceles'
        else 'Scalene'
        end as result
from triangles;