SQl hackerrank advanced select

 

Write a query identifying each record type in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table:

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

Takeaway: we can use case in SQL but we have to give after select along with columns syntax: case When condition then  value or string that need to printed in output after case statement ends with END 

Answer: 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 OR B = C OR A = C THEN 'Isosceles'

ELSE 'Scalene'

END

FROM TRIANGLES;

output: 

• Equilateral 

• Equilateral 

• Isosceles 

• Equilateral 

• Isosceles 

• Equilateral 

/* Enter your query here. */-- Result Set 1: Alphabetically ordered list of names with profession initial SELECT CONCAT(Name, '(', LEFT(Occupation, 1), ')') FROM Occupations ORDER BY Name; -- Result Set 2: Occupation counts SELECT CONCAT('There are a total of ', COUNT(Occupation), ' ', LOWER(Occupation), 's.') FROM Occupations GROUP BY Occupation ORDER BY COUNT(Occupation), Occupation;