leetcode+608. Tree Node+SQL+判断二叉树节点类型

链接

# Write your MySQL query statement below
select id, (
    case 
    when p_id is null then 'Root'
    when id in (select p_id from tree) then 'Inner'
    else 'Leaf'
    end
) as Type from tree