Solving the most complex SQL Problem on LeetCode | SQL Interview Question and Answer

In this video, we will solve the most complex SQL problem on LeetCode.
The problem is the LeetCode 1917. Leetcodify Friends Recommendation problem.
The problem is mentioned as HARD in LeetCode but after you see my solution, you may wonder if this was a MEDIUM problem (I definitely think so).

LeetCode problem link:

Download the scripts and dataset from below:

Thanks for watching!

[maradanaajaykumar]

Please do more leet code problems bro it helps us to understand complex problems

[vanshagrawal]

instead of l1.user_id < l2.user_id we can write l1.user_id !=l2.user_id so that we do not have to union the table at the end

[hassamulhaq]

because of previous sql videos I easily understand thelogic he used to write queries in this video. really thanks for such educational video.

[anonymousgreen]

Sir leetcode sql premium questions are difficult. Would appreciate few more videos on this topic.

[jirikalina]

You should definitely do another. Very good content Sir.

[GarvitaSaraswat-tr]

looking forward to more such videos! thanks in advance!

[iamdushyanta]

Could you please do more leet code problems?

[roz_world]

@techtfq sir please leetcode SQL problem solution series please

[sujaa]

Thank you very much! very very helpful. Look forward to more such problems.

[lioneleli]

Nice. Be posting leetcode solutions for sql.

[saadmultani]

Please do more leetcode complex problem

[bestquotes]

It's a good approach, but have one doubt do we need the valid_user cte?. Because we are anyway filtering it using having in a freinds cte.

[Mr.nikk]

Hii sir thanku for this quality video but sir i have a big question to solve in SQL sir there any way to connect with you and tell you the problem and other student also learn form the question
Kindly provide me the way to connect with you

[adesholaolaitan]

Please which tool are you using to record your screen?

[Naveenvuppala]

When you understand the logic and know the cte logic it's like playing game

[marrapumani]

sir try to make videos on transactions and cursors

[Malaika_ki_rahein]

sir please teach transaction management with real world exampless

[JoelJeremiah-vt]

For what roles are such questions asked in the interview, sir?

[rohit_vora]

hello everyone, i am having a tiny problem while writing query, if anyone could help me that would be so great. so, when i write query and press enter to go to next line, it automaticaly add some space at the begining which i don't want for ex:
(select * from abc
where aaa
group by bbb) somthin like this. if anyone knows what settings should i chaneg to write just like sir writing in the video, i would be so greatfull to you.

[MohdSaeed-gl]

Sir, I am clicking this question then require subscribe to unlock. Can you suggest me how it will open.