조건문 case when

binary tree nodes

select N,
       case when P is null then 'Root'
            when N in (select distinct P from BST) then 'Inner'
            else 'Leaf' end
from BST
order by N