6. Binary Tree Nodes | CASE, ORDER BY, BST | SQL Questions With Concepts

Question Link - www.hackerrank.com/challenges...
---------------------------------------------------------------------------
🔥𝐏𝐚𝐲 𝐀𝐟𝐭𝐞𝐫 𝐏𝐥𝐚𝐜𝐞𝐦𝐞𝐧𝐭
Newton School's 𝐅𝐮𝐥𝐥 𝐒𝐭𝐚𝐜𝐤 𝐂𝐨𝐮𝐫𝐬𝐞 𝟐𝟎𝟐𝟐 - bit.ly/FullStack2022
Newton School Official WhatsApp Support Number: [phone]
-----------------------------------------------------------------------------------
📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: t.me/arpitsinghplacement
📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: / newto. .
📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: / newtonschoo. .
📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: / newtonschool.co
------- 𝐀𝐛𝐨𝐮𝐭 𝐍𝐞𝐰𝐭𝐨𝐧 𝐒𝐜𝐡𝐨𝐨𝐥 -------
🔵NEWTON SCHOOL is an online Edtech company providing the highest-rated FULL STACK DEVELOPMENT PROGRAM for professionals, graduates, and women.
🌕NEWTON SCHOOL is your gateway to a high-paying tech career in 6 months with Zero fees till placement, transforming you into a rockstar full-stack developer earning 5-40 Lakh per annum salary. Newton School’s students are already working in more than 150+ top companies of India including Zomato, Unacademy, Deloitte, Nutanix, etc.
🔵To watch more videos on programming, Data Structures, Android Development, Data Science, C++, Java, React, subscribe to our channel.
- - - - - - - - - - - - - -
If you're reading this far down, hello, you look nice today :)
Tags:
Job Opportunities
Off Campus
Placement
Internship
Object-Oriented Programming
Operating System
Data structure
Arpit Singh
#Placementpreparation #interview #offcampus #jobopportunities #hiring #arpitsingh #NewtonSchool #NS #Fullstack #FSD #Datascience #MS #Postgrad #webdeveloper #programming #programmer #programmers #developer #coder #programmingmemes #coders #coding #frontenddeveloper #backenddeveloper #html #softwaredeveloper #hacking #python

[@knowledgebhajja2019]

bhai majja aa gya

[@chandansinghhh]

Bhai aap ney select kiyu use kiya second when main ?

[@ps6846]

Nice vdo bhai . But apna view toh hide kro, pura query dikh hi nhi rhi

[@preparationtoplacements]

Sure, sorry for the issue

[@khz2172]

it can be seen in 8:02

[@DishaSingh-ir6vl]

Her is the code:
select case
when P is null then concat(N,' Root')
when N in (select distinct P from BST) then concat(N,' Inner')
else concat(N,' Leaf')
end
from BST
order by N asc;