CASE WHEN 3

[LeetCode] 608. Tree Node

📢 본 포스팅에 활용되는 기본 문제 및 자료 출처는 리트코드 Problems, https://leetcode.com/problemset/all/임을 밝힙니다. ✔ 문제 https://leetcode.com/problems/tree-node/ Tree Node - LeetCode Can you solve this real interview question? Tree Node - Table: Tree +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | p_id | int | +-------------+------+ id is the primary key column for this table. Each row ..

[Hacker Rank] Occupations

📢 본 포스팅에 활용되는 기본 문제 및 자료 출처는 HackerRank 임을 밝힙니다. https://www.hackerrank.com ■ 문제 https://www.hackerrank.com/challenges/occupations/problem Occupations | HackerRank Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. www.hackerrank.com Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and di..

[Hacker Rank] Occupations

📢 본 포스팅에 활용되는 기본 문제 및 자료 출처는 HackerRank 임을 밝힙니다. https://www.hackerrank.com ■ 문제 https://www.hackerrank.com/challenges/occupations/problem?isFullScreen=true Occupations | HackerRank Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. www.hackerrank.com Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alp..