REAL SQL Interview Question | Complex SQL Interview Query and Solution

In this video, we shall look at a COMPLEX SQL Interview query which was shared to me by one of my subscribers. We shall understand the problem statement first and then try to solve it.

All the scripts, dataset and sql query can be downloaded for free from my blog or from my discord channel. Links below:

If you liked the video then do consider subscribing and giving me a like on the video.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq

[divyakamra]

Sir, please make a video on SQL index and it's different types as well it would be really helpful.

[vamsikrishna-yxxz]

Awesome. You explained it so nicely and made it simple for us to understand. Great job. Thanks a lot.

[krishna]

Thanks for coming up everytime with new problem statements and help us learn something new. Pls keep posting!!

[padhisambit]

Excellent explanation and so helpful !!!!

[mukesh_moorthy]

You are the best YouTube channel I have found for clear explanation on sql queries😄

[kotamrajusurya]

really helpful sir thank you very much for your efforts and please keep upload like this type of videos.thank you so much

[jamesphillipdeguzman]

I learned something from here. Thanks kind sir. Awesome content as always. Keep uploading more videos like this and maybe next time something that solves a real life business problem as well.

[sheikhsheharyar]

Toufeeq i would appreciate if you start making videos on cosmos DB

[ramchand]

Hi mentor, it was pleasure to subscribe your channel.. I m learning sql every nook and corner of the logic..im really grateful to come across ur channel... Thank u so much.. I have a doubt.. I'm 33 .im reforming my career in data analytics...could u share ur opinion

[sandeepkumar-ollg]

Hi, Could you please explain what’s the best way to write conditions in WHERE clause

[pawansahu]

Hi Taufiq.. Thanks for wonderful explanation. I have been trying same code with SQL server but getting error on recursive table "related_fam_members;

[travelnexpedition]

I don’t know why they ask such questions in interview. It doesn’t solve any business problems. Anyways, you did a good job.

[rhnwpvx]

Hi brother how are you? we are learning so many good things about sql you are way of explanation is superb i have a small request can you please do using stored procedures we will learn that process also please

[KiranKumar-hkji]

Sir can we use case statement to merge these 2columns into column3 and the. Work the solution

[SANDATA]

Mash Allah the lecture really helpful for all IT techs

[somethingnew]

Hi one request can you add the ms sql query also for this. Becoming kind of confusing.

[theresepraisethelord]

Can you do any healthcare example please for people who works with hospital data

[redwannabil]

Is there any alternative way to solve recursive sql queries?? And could you please provide some examples

[kancharalaparameshwarreddy]

sir plz provide video on views and indexes last video i never wont ask agin sir

[prudhvireddy]

Hi sir, when will you start live sessions