Solving SQL Interview Query | SQL Problem by Service based company

In this video we solve an SQL Interview query which was asked by one of the biggest IT services company in the world.
We have been given the cumulative sum of distance traveled by a car and we are required to write a SQL query to calculate the actual distance traveled by a car for each day.

In this video, I will not only provide you the solution but will also go through step by step on how to solve such problems, what should the thinking be when solving such SQL problems.

You can download the dataset, scripts and SQL Queries used in this video from my blog using below link:

Timestamp:
00:00 Intro
00:25 Understanding the problem statement
02:25 Showcasing the sample dataset
03:14 Coming up the approach to solving this SQL Problem
04:42 Solution to SQL Problem

🔴 My Recommended courses 👇

🔴 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

[joefromdc]

As a new person doing SQL, these are the type of videos that help your understanding. Thanks for the video

[abhijitsahani]

I finally got a job by daily learning from your videos

[anish_k]

I really like these kind of videos, short, yet full of concepts. Thanks a lot man.

[BipinKumar-outj]

It always worth to come to your channel for complex and advance SQL query. Please Keep it up.
Thanks a lot ❣️

[saktibiswal]

Thanks for the crisp explanation on LAG & its parameters.

[roshnakabdulsalam]

Hai Thoufiq,
Could you please make some videos on DAX in Power BI?
Since your classes are very much precise and clear, they will be much helpful for many data analyst aspirants like me.

[vasanthalakshmi]

Yes, cumulative based in service based so much necessary 👏

[ASofficial]

😍 Great efforts. the way you solve problem is too good. thnq for discussing these types of questions with us

[theshanerap]

SELECT *, distance - COALESCE (LAG(distance) over (), 0) as travelled_today FROM car

Thanks to your previous videos, I solved it without watching! You are the best!

[CAPVIVEK_GAMING_]

THESE VIDEO IS VERY HELPFUL
CAN YOU MAKE VIDEOS ON DATA TOOL SSIS, SSAS, SSRS SO I CAN LEARN EASILY

[mr.b]

This is the quality content brother ..keep helping and be blessed

[venkatarao]

I like your presentation of SQL class 👌 thnk u sir very help for your videos.. to me

[shaiksalman]

when i share this query my friends loved it so plz upload queries frequently

[_manav_paneliya]

Window function ❤️‍🔥 Your explanation 💯🫡

[Harishvlogs]

Nice explanation good job keep it up man

[vishalsonawane.]

Please upload more videos for interview SQL queries 🔥

[subha]

Amazing explanation. Best YouTube channel for SQL. I want some python projects for my data sc resume. Do u have any suggestions? Thanks Toufiq 👍

[rraagg]

Thank you very much. Great explanation!!

[pravinchincholkar]

a different world. It's the sa laws, but different application. Without your videos, I'm not sure I would be at the level I'm at. I'm not a pro

[NaeemKhan-qnvb]

aalampana, tussi great ho, tohfa kubool karo