610. Triangle Judgement
Problem Statement
Report for every three line segments whether they can form a triangle. Return the result table in any order.
Table Schema
Table: Triangle
+-------------+------+
| x | int |
| y | int |
| z | int |
+-------------+------+
(x, y, z) is the primary key.
Examples
Example 1
Input Table:
Triangle table:
+----+----+----+
| x | y | z |
+----+----+----+
| 13 | 15 | 30 |
| 10 | 20 | 15 |
+----+----+----+
Expected Output:
+----+----+----+----------+
| x | y | z | triangle |
+----+----+----+----------+
| 13 | 15 | 30 | No |
| 10 | 20 | 15 | Yes |
+----+----+----+----------+
SQL Solution
SELECT x, y, z,
CASE WHEN x + y > z AND x + z > y AND y + z > x
THEN 'Yes' ELSE 'No' END AS triangle
FROM Triangle;
Problem Info
DifficultyEASY
Topics
case-when
Reference Links