쿼리문4 [SQL] 해커랭크 HackerRank Interviews 문제 풀이 문제Samantha interviews many candidates from different colleges using coding challenges and contests. Write a query to print the contest_id, hacker_id, name, and the sums of total_submissions, total_accepted_submissions, total_views, and total_unique_views for each contest sorted by contest_id. Exclude the contest from the result if all four sums are .Note: A specific contest can be used to screen.. 2025. 3. 19. [SQL] 해커랭크 HakerRank 문제 풀이 Symmetric Pairs 문제 You are given a table, Functions, containing two columns: X and Y. (그림 확인)Two pairs (X1, Y1) and (X2, Y2) are said to be symmetric pairs if X1 = Y2 and X2 = Y1.Write a query to output all such symmetric pairs in ascending order by the value of X. List the rows such that X1 ≤ Y1. 해석주어진 테이블 **Functions**에는 두 개의 컬럼 **X**와 **Y**가 존재한다.이 테이블에서 **대칭 쌍(Symmetric Pairs)**을 찾아야 한다.두 개의 쌍 (X1, Y1)과 (X2.. 2025. 3. 17. [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 Occupations 문제 풀이 문제Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, Professor, Singer, and Actor) in that specific order, with their respective names listed alphabetically under each column.Note: Print NULL when there are no more names corresponding to an occupation. 해석 O.. 2025. 3. 13. 이전 1 다음
