Data Analysis SQL Interview Questions | Running SUM | Who Hit the Sales Target First

[@johnvak7390]

I started learning sql 2 month ago, and man I woulda been lost if i saw this. Now that 2 month have past, I can understand this. Woo

[@absentdata]

So glad that you were able to found my content too

[@SapeHallward]

What resources do you use most to learn sql?

[@johnvak7390]

@@SapeHallward SQL beginner courses on KZbin

[@TheDataworm]

@@absentdata find*

[@mauthoigian8027]

I think you should divide the problem into 2 parts: 1.employee reaching 100k earliest and 2.employee reaching 100k fastest. Your solution helps with the 1st prob and the 2nd problem should use other logic (compare the days it takes for each emp to get 100k sales ) 🎉

[@absentdata]

Nice approach

[@brandoncyoung]

Really great SQL tip!

[@absentdata]

Glad it was helpful!

[@southafricangamer7174]

I had to take it in piece by piece and understood :)

[@absentdata]

Thats the best way to learn. Great!

[@shashidharr6595]

i love your videos thank you so much for teaching nice

[@absentdata]

Glad you're enjoying them!

[@dany5961]

If you keep sql script for the table solving in description is helpful to practice .

[@SergiusBfg]

You window func in ussless. You can group BEFORE selection. And try CTE. It will be more performaanced

[@HarshKumar-jw7eu]

Fall in love with this query

[@ubaid1231]

Sir, please share table also, so, we practice in sql server by hand..

[@Gauravkumar-wk1rf]

Can you provide tables database in your shorts or channel

[@deaconwill2430]

really good explanation

[@gurubellimanoharsai7416]

what is meant for order by 2 here

[@absentdata]

order by the second column

[@Thekingslayer-ig5se]

Great one bro

[@absentdata]

I appreciate it!

[@zg3671]

Excel can solve this with the ifs function

[@apamwamba]

sure but this about SQL

[@suryateja1320]

What is the sql application we should use to learn for data analytics for begginers

[@absentdata]

MySQL is a good one

[@Gauravkumar-wk1rf]

Nice video

[@akkshhey09]

Why did you do MIN(sale_date)?

[@absentdata]

We want to get the first date at which the sum was 100,000 or more. So we use the MIN() to get that date

[@sanjeevkumawat9694]

I this question could be solved by this way also: Select salesperson_name, min(sale_date) as target from sales_data Group by salesperson_name Having sum(amount)= 100000 Order by target

[@absentdata]

This query will only return the first date where the sales person had a single day of sales at the 10000. It does not account for the previous sales. So a running total is needed.

[@urdaty]

What does order by 2 mean?

[@koushikkanumuri253]

it means order by 2nd column , in this case it's sale date

[@absentdata]

Second column

[@tuturam2510]

what software guys?

[@absentdata]

Microsoft SQL Server Studio but Windows Functions work in most DBMS with the exception of SQL lite and a few others.

[@Smile-et3fe]

what does partition by do?

[@absentdata]

It sets a window or group in which you want to do something with. In this case, we want the running sum of each sales person. So the partition is each sales person

[@alexkuznetsov5958]

Very poor video

[@absentdata]

Thanks

[@ubaid1231]

Why poor ?

[@mitty3674]

@@absentdataplease continue making these videos they’re really helpful