Practice SQL Interview Query | Big 4 Interview Question

The first 1,000 people to use the link will get a 1 month free trial of Skillshare: https://skl.sh/techtfq09221 In this video, I will be solving a REAL SQL Interview Questions asked during an interview by one of the BIG 4 Accounting firms (PwC, EY, KPMG, Deloitte). This is a very common question asked during SQL Interviews hence we shall look at the approach and the thinking you need to have when solving these kind of SQL problems. If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇 https://sqlnest.com/ All the dataset, scripts and SQL queries used in this video can be downloaded for free from my website. Link below: https://techtfq.com/blog/practice-sql... Timestamp: 00:00 Intro 00:28 Understanding the problem statement 02:21 Approach to solve similar SQL Problem 06:05 Free Skillshare promo link 07:41 Solution to SQL Problem FTC disclaimer: This video was sponsored by Skillshare. 🔴 My Recommended courses 👇 ✅ FREE SQL Practice course (valid only until 30-Sep-2022): https://learnsql.com/course/postgresq... ✅ Learn complete SQL: https://learnsql.com/?ref=thoufiqmoha... ✅ Practice SQL Queries: https://www.stratascratch.com/?via=te... ✅ Learn Python: https://codebasics.io/courses/python-... ✅ Learn Power BI: https://codebasics.io/courses/power-b... 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts:    • SQL Tutorial - Basic concepts   ✅ SQL Tutorial - Intermediate concepts:    • SQL Tutorial - Intermediate concepts   ✅ SQL Tutorial - Advance concepts:    • SQL Tutorial - Advance concepts   ✅ Practice Solving Basic SQL Queries:    • Practice Solving BASIC SQL Queries   ✅ Practice Solving Intermediate SQL Queries:    • Practice Solving INTERMEDIATE SQL Queries   ✅ Practice Solving Complex SQL Queries:    • Practice Solving COMPLEX SQL Queries   ✅ Data Analytics Career guidance:    • Data Analytics career and more   ✅ SQL Course, SQL Training Platform Recommendations:    • SQL Course / Training   ✅ Python Tutorial:    • Python Tutorial   ✅ Git and GitHub Tutorial:    • Git and GitHub   ✅ Data Analytics Projects:    • Data Analytics Projects   THANK YOU, Thoufiq