We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Donts
1.Remove column values
2.Remove order by
3.Only Equilateral, Scalene, Isocelese and Not A Triangle are expected outputs.. So 20,20,40 should be reported a 'Not A Triangle'. (This is confusing to me also)
I tried this, which worked when I set the problem up on my own MySQL but failed the code test. Anyone know why?
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 and B != C then 'Isosceles'
when A!=B and B!=C and A!=C then 'Scalene'
end as Type
from triangles;
Sorry, there was a logical error there, which I found by adding more examples. This now seems to work fine though, but it still doesn't like it:
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 and B!=C) or (A=C and C!=B) or (B=C and C!=A) then 'Isosceles'
when A!=B and B!=C and A!=C then 'Scalene'
else 'Balls Up'
end as Type
from triangles;
Type of Triangle
You are viewing a single comment's thread. Return to all comments →
Do Output only the triangle names
Donts 1.Remove column values 2.Remove order by 3.Only Equilateral, Scalene, Isocelese and Not A Triangle are expected outputs.. So 20,20,40 should be reported a 'Not A Triangle'. (This is confusing to me also)
Try it ..Cheers...
I tried this, which worked when I set the problem up on my own MySQL but failed the code test. Anyone know why?
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 and B != C then 'Isosceles' when A!=B and B!=C and A!=C then 'Scalene' end as Type from triangles;
Sorry, there was a logical error there, which I found by adding more examples. This now seems to work fine though, but it still doesn't like it:
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 and B!=C) or (A=C and C!=B) or (B=C and C!=A) then 'Isosceles' when A!=B and B!=C and A!=C then 'Scalene' else 'Balls Up' end as Type from triangles;