728x90 Data Base/Hacker Rank1 HackerRank SQL) Binary Tree Nodes HackerRank SQL) Binary Tree Nodes 문제 Binary Tree Nodes | HackerRank Binary Tree Nodes | HackerRank Write a query to find the node type of BST ordered by the value of the node. www.hackerrank.com Code SELECT CUR.N, CASE WHEN CUR.P IS NULL THEN 'Root' WHEN CUR.N IN (SELECT DISTINCT NXT.P FROM BST AS NXT WHERE NXT.P IS NOT NULL) THEN 'Inner' ELSE 'Leaf' END FROM BST AS CUR ORDER BY CUR.N ASC; 설명 SE.. 2022. 1. 15. 이전 1 다음 728x90
