• + 0 comments

    SELECT CASE WHEN (A+B>C AND B+C>A AND A+C>B) THEN (CASE WHEN A=B AND B=C AND A=C THEN 'Equilateral' WHEN A=B OR A=C OR B=C THEN 'Isosceles' ELSE 'Scalene' END) ELSE 'Not A Triangle' END from TRIANGLES; [I have checked the triangle condition first and then when on checking the sides of the triangle conditions].