[SQL] 리트코드 610. Triangle Judgement

문제

Table: Triangle

+-------------+------+
| Column Name | Type |
+-------------+------+
| x           | int  |
| y           | int  |
| z           | int  |
+-------------+------+

In SQL, (x, y, z) is the primary key column for this table.
Each row of this table contains the lengths of three line segments.
 
Report for every three line segments whether they can form a triangle.
Return the result table in any order.
The result format is in the following example.

 

https://leetcode.com/problems/triangle-judgement/description/

Triangle Judgement - LeetCode

예시

Input: 
Triangle table:

+----+----+----+
| x  | y  | z  |
+----+----+----+
| 13 | 15 | 30 |
| 10 | 20 | 15 |
+----+----+----+

Output: 

+----+----+----+----------+
| x  | y  | z  | triangle |
+----+----+----+----------+
| 13 | 15 | 30 | No       |
| 10 | 20 | 15 | Yes      |
+----+----+----+----------+

문제 풀이

SELECT x
     , y
     , z
     , IF(x+y > z AND x+z > y AND y+z > x, 'Yes', 'No') AS triangle
FROM triangle;

---

SQL을 독학하시는 분들에게 도움이 되길 바라며,

혹 더 좋은 방법이 있거나 오류가 있다면 편하게 말씀 부탁드립니다.