05.AS01-TypeofTriangle.sql

/*
Type of Triangle

Write a query identifying the type of each record 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.

Input Format

The TRIANGLES table is described as follows:
+--------+---------+
| COLUMN |  TYPE   |
+--------+---------+
| A      | Integer |
| B      | Integer |
| C      | Integer |
+--------+---------+

Each row in the table denotes the lengths of each of a triangle's three sides.

Sample Input

+----+-----+----+
| A  |  B  | C  |
+----+-----+----+
| 20 | 20  | 23 |
| 20 |  20 | 20 |
| 20 |  21 | 22 |
| 13 |  14 | 30 |
+----+-----+----+

Sample Output

Isosceles
Equilateral
Scalene
Not A Triangle

Explanation

Values in the tuple (20,20,23) form an Isosceles triangle, because A= B .
Values in the tuple (20,20,20) form an Equilateral triangle, because A = B = C. 
Values in the tuple (20,21,22) form a Scalene triangle, because A!= B != C.
Values in the tuple (13,14,30) cannot form a triangle because the combined value of sides A and B is not larger than that of side C.
*/

use hackerrank;

GO

raiserror('Now at the create procedure section ....',0,1)

GO

CREATE or ALTER PROCEDURE advancedselect.proc_01typeoftriangle AS
select
	CASE 
		when (((A+B) <= C) or ((B+C) <= A) or ((C+A) <= B))  then 'Not A Triangle'
		when ((A=B) and (B=C)) then 'Equilateral'
		when ((A=B) or (B=C) or (C=A)) then 'Isosceles'
		else 'Scalene'
	end
from advancedselect.TRIANGLES;
GO

CREATE or ALTER PROCEDURE AdvancedSelectTestClass.test_01typeoftriangle
AS
BEGIN
    IF OBJECT_ID('actual') IS NOT NULL DROP TABLE actual;
    IF OBJECT_ID('expected') IS NOT NULL DROP TABLE expected;

	CREATE TABLE actual (
	      RESULT		varchar(25)        NOT NULL,
    );

    INSERT INTO actual (RESULT) exec advancedselect.proc_01typeoftriangle

    CREATE TABLE expected (
	      RESULT		varchar(25)        NOT NULL,
    );

	INSERT INTO expected (RESULT) SELECT 'Equilateral'
	INSERT INTO expected (RESULT) SELECT 'Equilateral'
	INSERT INTO expected (RESULT) SELECT 'Isosceles'
	INSERT INTO expected (RESULT) SELECT 'Equilateral'
	INSERT INTO expected (RESULT) SELECT 'Isosceles'
	INSERT INTO expected (RESULT) SELECT 'Equilateral'
	INSERT INTO expected (RESULT) SELECT 'Scalene'
	INSERT INTO expected (RESULT) SELECT 'Not A Triangle'
	INSERT INTO expected (RESULT) SELECT 'Scalene'
	INSERT INTO expected (RESULT) SELECT 'Scalene'
	INSERT INTO expected (RESULT) SELECT 'Scalene'
	INSERT INTO expected (RESULT) SELECT 'Not A Triangle'
	INSERT INTO expected (RESULT) SELECT 'Not A Triangle'
	INSERT INTO expected (RESULT) SELECT 'Scalene'
	INSERT INTO expected (RESULT) SELECT 'Equilateral'

    EXEC tSQLt.AssertEqualsTable 'expected', 'actual';

END;

GO

--exec tSQLt.Run 'AdvancedSelectTestClass.[test_01typeoftriangle]';