Binary Tree Nodes HackerRank SQL

Binary Tree Nodes
HackerRank
SQL Advanced Select

[navneetkushwaha]

I subscribed ur channel because I got the easiest solution.

[MsRachelesquivel]

I entered it like this, got the same results as you, but its telling me wrong answer :(

SELECT N,
CASE
WHEN P IS NULL THEN 'ROOT' --no parent
WHEN N IN (SELECT P FROM BST) THEN 'INNER' --node is a parent
ELSE 'LEAF'
END
FROM BST
ORDER BY N;