Solving SQL Interview Query using SELF JOIN

Written By Thoufiq Mohammed

In this video, we look at another SQL interview query. We shall solve this problem using SELF JOIN concept of SQL.

The problem statement might seem complex but the solution is pretty simple. I will explain how SELF JOIN works and the logic and thinking behind solving such SQL problems during interviews.

Download the dataset and SQL queries used in this video from below link:

Thoufiq Mohammed https://techtfq.com
Previous

Tricky SQL Interview Query
Next

Solving SQL Interview Query | SQL Problem by Service based company