Tricky SQL Interview Query | Practice Solving SQL Interview Queries

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. In order to better understand this problem solution, I recommend you watch my previous video first. Link below: Download the dataset and scripts used in this video from my blog below: Timestamp: 00:00 Intro 00:32 Understanding the problem statement 02:17 Solving the SQL Problem 🔴 My Recommended courses 👇 ✅ FREE SQL Practice course (valid only until 30-Sep-2022): ✅ Learn complete SQL: ✅ Practice SQL Queries: ✅ Learn Python: ✅ Learn Power BI: 🔴 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: ✅ Git and GitHub Tutorial: ✅ Data Analytics Projects: THANK YOU, Thoufiq