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:
leetcode.com/p...
Download the scripts and dataset from below:
techtfq.com/bl...
Thanks for watching!

[@anonymousgreen5080]

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

[@maradanaajaykumar3657]

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

[@kyleebrahim8061]

This guy is a SQL genius

[@mohansai9109]

Please do more leet code problems

[@RRR5670]

sir please come up with a series❤

[@vanshagrawal6896]

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

[@shafaligarg1796]

He's crazy talented man 🤯 kudos

[@saadmultani7251]

Please do more leetcode complex problem

[@iamdushyanta]

Could you please do more leet code problems?

[@sujaa1000]

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

[@roz_world]

@techtfq sir please leetcode SQL problem solution series please

[@lioneleli5963]

Nice. Be posting leetcode solutions for sql.

[@bestquotes2765]

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.

[@MohdSaeed-g6l]

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

[@JoelJeremiah-v5t]

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

[@Malaika_ki_rahein]

please teach us by reference of KORTH BOOK

[@DelbertAkiyama-c7z]

Rodriguez Jessica Walker Eric Thompson Charles