HackerRank2 [SQL] HackerRank - 핵심 문제만 풀어보기 - (2) ◈ HackerRank의 일부 문제(Easy 제외)와 해설을 복원한 글 ◈ 오류 정정 및 피드백 환영 Contest Leaderboard [문제] Write a query to print the hacker_id, name, and total score of the hackers ordered by the descending score. The total score of a hacker is the sum of their maximum scores for all of the challenges. If more than one hacker achieved the same total score, then sort the result by ascending hacker_id. Exclude all hacker.. 2022. 2. 17. [SQL] HackerRank - 핵심 문제만 풀어보기 - (1) ◈ HackerRank의 일부 문제(Easy 제외)와 해설을 복원한 글 ◈ 오류 정정 및 피드백 환영 The PADs [문제] Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses). For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S). Query the number of occurrences of each occupation in OCCUPATIONS.. 2022. 2. 16. 이전 1 다음
