-
leetcode - 610. Triangle JudgementSQL 문제풀이 2022. 7. 13. 16:52
난이도 : Easy
Table: Triangle
+-------------+------+ | Column Name | Type | +-------------+------+ | x | int | | y | int | | z | int | +-------------+------+ (x, y, z) is the primary key column for this table. Each row of this table contains the lengths of three line segments.
Write an SQL query to report for every three line segments whether they can form a triangle.
Return the result table in any order.
The query result format is in the following example.
Example 1:
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 , CASE WHEN x+y <= z OR x+z <= y OR y+z <= x THEN 'No' ELSE 'Yes' END triangle FROM Triangle
Accepted (10.54%)
'SQL 문제풀이' 카테고리의 다른 글
leetcode - 1527. Patients With a Condition (0) 2022.07.14 leetcode - 1517. Find Users With Valid E-Mails (0) 2022.07.14 leetcode - 1098. Unpopular Books (0) 2022.07.13 leetcode - 1077. Project Employees III (0) 2022.07.13 leetcode - 1511. Customer Order Frequency (0) 2022.07.12