Solving an SQL Interview Problem

In this video, let's solve an SQL interview query taken from LeetCode.
The problem might seem complex at first but there is a very simple solution to solve such problems so lets explore it in this video.

[TY-zlvw]

I have experienced more than one occasions having hard time understanding what the questions are trying to ask. Then after seeing the solution, then understand the questions.

[adityavamsi]

Select id,
Case when p_id is null then "Root"
When id not in (select distinct p_id from tree) then "Leaf"
Else "Inner"
End as type
From tree;

[satyammishra]

yes sir many times seeing a solution makes it very easy

[HorseEngine]

Solved this on leetcode. It's a simple select use case or union query.

[kumark]

DECODE ( ID, 1, 'ROOT', 2, 'INNER', 'LEAF') Type

[pradeepdhanola]

I follow and watch your all videos sir and learn .agg cte, sub, window query in better way❤

[yasink]

Very congratulations for blessed with Son's🎉🎉🎉

[chikachika]

I wish I can just learn how to write complex queries from u. Especially the cte. How to break questions down

[PalestineJourney]

Using self join and case for this solution...

[naiyarazad]

Thanks for sharing I really liked the way you solve a query. I have one question that was asked in interview.
there is sequence of numbers in "ID" column of a table and it contains values as (1, 2, 3, 50, 51, 56, 60).
so expected output should be like
gaps_start gaps_end

4 49
52 55
57 59

please share your idea how to solve this.

[sorvex]

And this is why that is a stupid question to ask at an interview. Because in a real job situation they would have researched it with Google and quickly come up with a solution.

[alokkumarsahu]

I have one scenario based questions reg SQL table, in this page no option to share the table, so could please help me to reach out to you.

[MSDMSD]

Hi TFQ, i would like to know how to do a column mapping without using minus or not exist or not in as a part of ETL validation. can you please come up with this?? Thanks

[guitarclasses-]

Sir actually I just want to know

How can I export my SQL data after shorting please let me know

[kiranratnakara]

Brother I want to join your training sessions... please tell me the amount details

[nigistbinyam]

hi you good teacher I would like attend the class can you send me the link? if you have boot camp