• + 0 comments

    SELECT CASE -- Check if it is not a triangle first WHEN A + B <= C OR B + C <= A OR A + C <= B THEN 'Not A Triangle' -- Check if it is Equilateral WHEN A = B AND B = C THEN 'Equilateral' -- Check if it is Isosceles WHEN A = B OR B = C OR A = C THEN 'Isosceles' -- Check if it is Scalene WHEN A != B AND B != C AND A != C THEN 'Scalene' END AS type FROM TRIANGLES;