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:
https://www.youtube.com/watch?v=WhkNQ3g0U64&t=26s

Download the dataset and scripts used in this video from my blog below:
https://techtfq.com/blog/tricky-sql-interview-query

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): https://learnsql.com/course/postgresql-queries-online-practice

✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmohammed

✅ Practice SQL Queries: https://www.stratascratch.com/?via=techTFQ

✅ Learn Python: https://codebasics.io/courses/python-for-beginner-and-intermediate-learners?refId=70170e4c-7511-4c83-b769-c5cc8339c731

✅ Learn Power BI: https://codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project?refId=4b1e1886-3252-4bf1-86f4-7d603dab692f


? WATCH MORE VIDEOS HERE ?

✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO

✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii

✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7

✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp

✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV

✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--

✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P

✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n

✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW

✅ Git and GitHub Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9EI1MPlqqDpe3bgr8RJZE0b

✅ Data Analytics Projects:
https://www.youtube.com/playlist?list=PLavw5C92dz9HwT_uStsDdJbuBOt_XD0ch

THANK YOU,
Thoufiq