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-tricky-sql-interview-query

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=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

Видео Solving a tricky SQL Interview Query канала techTFQ