Tricky SQL Interview Query

Written By Thoufiq Mohammed

In this video, we solve a Tricky SQL Interview Query. This is an intermediate level SQL problem that can be asked during interviews.

This problem might seem similar to the one I solved in my previous video but this is far more complex than the previous one since we need to transform the data first, before applying the logic to derive the final output.

Download the dataset and scripts from below:

Thoufiq Mohammed https://techtfq.com
Previous

SQL Interview Problem asked by Product Based Company
Next

Solving SQL Interview Query using SELF JOIN