Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Binary Tree Nodes Solution

Also Visit:  Occupations Solution

Problem

You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N.

Write a query to find the node type of Binary Tree ordered by the value of the node. Output one of the following for each node:

• Root: If node is root node.
• Leaf: If node is leaf node.
• Inner: If node is neither root nor leaf node.

Sample Input

Sample Output

1 Leaf
2 Inner
3 Leaf
5 Root
6 Leaf
8 Inner
9 Leaf

Solution – Binary Tree Nodes Solution

MySQL Code

SELECT N, IF(P IS NULL,"Root",
IF((SELECT COUNT(*) FROM BST WHERE P=B.N)>0,"Inner","Leaf")) 
FROM BST AS B ORDER BY N;

What is Binary Tree Data Structure?

Binary Tree is defined as a tree data structure where each node has at most 2 children. Since each element in a binary tree can have only 2 children, we typically name them the left and right child.

Binary Tree Representation

A Binary tree is represented by a pointer to the topmost node (commonly known as the “root”) of the tree. If the tree is empty, then the value of the root is NULL. Each node of a Binary Tree contains the following parts:

• Data
• Pointer to left child
• Pointer to right child

Basic Operation On Binary Tree:

• Inserting an element.
• Removing an element.
• Searching for an element.
• Traversing the tree.

Auxiliary Operation On Binary Tree:

• Finding the height of the tree
• Find the level of a node of the tree
• Finding the size of the entire tree.

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.