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
@absentdata7 ай бұрын
So glad that you were able to found my content too
@SapeHallward23 күн бұрын
What resources do you use most to learn sql?
@johnvak739022 күн бұрын
@@SapeHallward SQL beginner courses on KZbin
@TheDataworm12 күн бұрын
@@absentdata find*
@mauthoigian802711 ай бұрын
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 ) 🎉
@absentdata11 ай бұрын
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!
@dany596110 күн бұрын
If you keep sql script for the table solving in description is helpful to practice .
@SergiusBfg6 ай бұрын
You window func in ussless. You can group BEFORE selection. And try CTE. It will be more performaanced
@HarshKumar-jw7eu2 ай бұрын
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
@deaconwill24302 ай бұрын
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
@apamwamba6 күн бұрын
sure but this about SQL
@suryateja13205 ай бұрын
What is the sql application we should use to learn for data analytics for begginers
@absentdata5 ай бұрын
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 ?
@mitty367422 күн бұрын
@@absentdataplease continue making these videos they’re really helpful