All Downloads are FREE. Search and download functionalities are using the official Maven repository.

g0601_0700.s0610_triangle_judgement.readme.md Maven / Gradle / Ivy

There is a newer version: 1.30
Show newest version
610\. Triangle Judgement

Easy

SQL Schema

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




© 2015 - 2024 Weber Informatics LLC | Privacy Policy