[SQL문제풀기] Type of Triangle

문제

Type of Triangle | HackerRank

Query a triangle's type based on its side lengths.

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

MySQL, Oracle, MS SQL Server, DB2

select case
when a>=b+c or b>=a+c or c>=a+b then 'Not A Triangle'
when a=b and b=c then 'Equilateral'
when a=b or b=c or c=a then 'Isosceles'
else 'Scalene' end tri
from TRIANGLES;