728x90 반응형 SMALL HACKERS RANK2 Hackers Rank : SQL Oracle : Type of Triangle solution # Q 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'.. 2022. 6. 2. Hackers Rank : SQL Oracle : Weather Observation Station 5 solution # Q Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. # A SELECT CITY, LENGTH(CITY) FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY) WHERE ROWNUM=1; SELECT CI.. 2022. 6. 1. 이전 1 다음 728x90 반응형 LIST