Question

3053. Classifying Triangles by Lengths

English Version

题目描述

Table: Triangles

+-------------+------+ 
| Column Name | Type | 
+-------------+------+ 
| A       | int  | 
| B       | int  |
| C       | int  |
+-------------+------+
(A, B, C) is the primary key for this table.
Each row include the lengths of each of a triangle's three sides.

Write a query to find the type of triangle. Output one of the following for each row:

• Equilateral: It's a triangle with 3 sides of equal length.
• Isosceles: It's a triangle with 2 sides of equal length.
• Scalene: It's a triangle with 3 sides of differing lengths.
• Not A Triangle: The given values of A, B, and C don't form a triangle.

Return _the result table in any order_.

The result format is in the following example.

 

Example 1:

Input: 
Triangles table:
+----+----+----+
| A  | B  | C  |
+----+----+----+
| 20 | 20 | 23 |
| 20 | 20 | 20 |
| 20 | 21 | 22 |
| 13 | 14 | 30 |
+----+----+----+
Output: 
+----------------+
| triangle_type  | 
+----------------+
| Isosceles    | 
| Equilateral  |
| Scalene    |
| Not A Triangle |
+----------------+
Explanation: 
- Values in the first row from an Isosceles triangle, because A = B.
- Values in the second row from an Equilateral triangle, because A = B = C.
- Values in the third row from an Scalene triangle, because A != B != C.
- Values in the fourth row cannot form a triangle, because the combined value of sides A and B is not larger than that of side C.

解法

方法一：使用 CASE WHEN 语句

我们可以使用 CASE WHEN 语句来判断三角形的类型。

首先，我们需要判断三个边是否能够构成一个三角形。如果不能，我们返回 Not A Triangle。

然后，我们判断三个边的长度是否相等。如果相等，我们返回 Equilateral。

接着，我们判断是否有两个边的长度相等。如果有，我们返回 Isosceles。

否则，说明三个边的长度都不相等，我们返回 Scalene。

# Write your MySQL query statement below
SELECT
  CASE
    WHEN A + B <= C
    OR A + C <= B
    OR B + C <= A THEN 'Not A Triangle'
    WHEN A = B
    AND B = c THEN 'Equilateral'
    WHEN (A = B) + (B = C) + (A = C) = 1 THEN 'Isosceles'
    ELSE 'Scalene'
  END AS triangle_type
FROM Triangles;