REAL SQL Interview Question | Complex SQL Interview Query and Solution



Published
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.
This complex SQL query is about finding all the family members from a given table. We need to group together members from the same family and then give a unique family id for each family.I have solved the problem using recursive sql query but of course you may have other solutions to the same problem. In case you do, then do not hesitate to share your solution in the comments below or you can email me your solution at [email protected]

All the scripts, dataset and sql query can be downloaded for free from my blog or from my discord channel. Links below:
Blog: https://techtfq.com/video/real-sql-interview-query-complex-sql-interview-query-and-solution
Discord channel: https://discord.gg/8aRSbygbdu

Recursive SQL Queries Tutorial: https://www.youtube.com/watch?v=7hZYh9qXxe4&t=1450s

My recommended SQL Course: https://learnsql.com/?ref=thoufiqmohammed
My recommended SQL practice platform: https://www.stratascratch.com/?via=techTFQ

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

Thank you,
Thoufiq
Category
Job
Be the first to comment