Solving a tricky SQL Interview Query
In this video, let's solve an SQL query which can be pretty commonly asked during SQL interviews.
This is a basic to intermediate level of SQL interview problem which can be commonly asked during interviews. If not the same problem but problems similar to this can be asked.
By practicing to solve these kind of sql queries, you will get to know how to use window functions, frame clause, cte and more importantly how to apply simple logics when solving sql problems.
Download the dataset and scripts from my blog below:
https://techtfq.com/blog/solving-a-tr...
Timestamp:
00:00 Intro
00:11 Understanding the problem statement
04:30 Steps to be taken to solve the SQL problem
05:30 Writing the SQL query
🔴 My Recommended courses 👇
✅ 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 Que...
✅ 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
