Sort by

recency

|

3571 Discussions

|

  • + 0 comments

    SELECT CASE WHEN A + B <= C OR A + C <= B OR B + C <= A THEN 'Not A Triangle' WHEN A = B AND B = C THEN 'Equilateral' WHEN A = B OR B = C OR A = C THEN 'Isosceles' ELSE 'Scalene' END AS TRIANGLE_TYPE FROM TRIANGLES;

  • + 0 comments

    INITIALLY I USED SELECT CASE WHEN (A + B <= C) OR (B+C<= A) OR (A+C<= B) THEN "Not a Triangle" ELSE #THEN WE CHECK THE MOST specific one CASE WHEN A = B AND B = C THEN "Equilateral" WHEN A = B OR B = C OR A = C THEN "Isosceles" ELSE "Scalene" END END AS TYPE BUT IT DIDNT WORK, SO I SWICHED TO

    SELECT CASE
    WHEN A + B > C AND B + C > A AND A + C > B THEN CASE WHEN A = B AND B = C THEN 'Equilateral' WHEN A = B OR B = C OR A = C THEN 'Isosceles' ELSE 'Scalene' END ELSE 'Not A Triangle' END FROM TRIANGLES;

    apart from the fact that i started with the true instead of the false this time i dont get why the first one did not work

    FROM TRIANGLES;

  • + 0 comments

    select case when a+b<=c OR A+C<=B OR B+C<=A 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 as triangle from TRIANGLES;

    //THIS CODE IS CORRECT BUT TEST CASES ARE NOT RUN THEN WHAT IS THE ERROR

  • + 0 comments

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

  • + 1 comment

    I'm not understanding why my input is wrong ;( pls help

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