sql문제4 [SQL] 해커랭크 HackerRank Placements 문제 풀이 문제You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID (ID of the ONLY best friend). Packages contains two columns: ID and Salary (offered salary in $ thousands per month).Write a query to output the names of those students whose best friends got offered a higher salary than them. Names must be orde.. 2025. 3. 16. [SQL] 해커랭크 HackerRank 문제 풀이 Type of Triangle - Advanced Select 문제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 f.. 2025. 3. 11. [SQL] 해커랭크 HackerRank 문제 풀이 Higher Than 75 Marks [SQL] hakerrank 문제 풀이문제Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID. 한국어 버전STUDENTS 테이블에서 75점보다 점수가 높은 학생의 Name 출력하라.각 이름의 마지막 3개 문자로 정렬하라.만약 마지막 3개 문자 이름이 같다면 ID를 .. 2025. 3. 8. [SQL] HackerRank 해커랭크 문제 풀이 Weather Observation Station 12 문제 Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. 다음 SQL 쿼리는 STATION 테이블에서 CITY 이름을 조회하는데, 다음 조건을 만족하는 경우만 선택합니다.CITY 이름이 모음(a, e, i, o, u)으로 시작하지 않는다.CITY 이름이 모음(a, e, i, o, u)으로 끝나지 않는다.결과에서 중복을 제거한다. 정답select distinct cityfrom stationwhere city not regexp '^[AEUIO]' and city not regexp '[AEUIO]$' 추가 .. 2025. 3. 7. 이전 1 다음
