GeezerVison is showing github.com — leetcode-sql/610. Triangle Judgement.sql at master · faaydan/leetcode-sql

Expand file tree

610. Triangle Judgement.sql

Copy path

More file actions

Latest commit

History

50 lines (39 loc) · 1.06 KB

610. Triangle Judgement.sql

Copy path

File metadata and controls

50 lines (39 loc) · 1.06 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

-- Problem

-- +-------------+------+

-- | 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.

-- 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 |

-- +----+----+----+----------+

-- Solution

select x, y, z, (

case

when abs(x) + abs(y) > abs(z)

and abs(y) + abs(z) > abs(x)

and abs(z) + abs(x) > abs(y) then 'Yes'

else 'No'

end

) triangle

from Triangle;