Yet another "WOW!" lesson for me. Don't think I've ever gotten to WINDOW Functions before. Very cool. I suppose it will all start to make more sense once I start using all of this on a regular basis. Am REALLY glad I figured out how to run an almost current version of MySQL on my macBook Pro in macOS Sonoma. Much simpler than using a VM, etc. Anyway, Alex's courses have always been well worth the time I invest. Thanks for putting up quality content Alex!
I watch this video every time I have an interview and I am just realizing that all the names in the table are characters from Parks and Recreation!! :) ❤
Great video! Thanks Alex, you made something that seems quite complicated, fairly simple and easy to understand. What are some other use cases for using a Window Function? I've heard having a mastery of these is what folks in the industry use as a gauge to see if someone truly understands SQL.
Hi. On your analystbuilder the “on the way out” question, the question says to order the output from oldest to youngest but the answer that will be counted as correct has the answer as ASC. The true answer should be DESC.
@@TheeGirl- you are not understanding the question. Let me break it down, ASC means the values are sorted from smallest to largest (vice versa for DESC). In this case, ordering by ASC for birth_date means from the earliest date (oldest) to the latest date (youngest). Therefore, using ASC will correctly order the output to identify the oldest employees first. hoped this helped
Hello, started the full project on "Data Cleaning", trying to INSERT layoffs_staging, with layoffs. My actions are correct but i am not getting any table. Dont know what i am doing wrong
Loving the tutorials! Quick question - I tried to put in the partition by code, it looks exactly the same as in the video, but I'm getting error code 1064. why isn't it working for me? the main issue: MySQL isn't accepting a parenthesis after OVER.
Hi Alex, I watch your tutorials, it's really nice and understandable, thanks a lot. I have a problem. Despite it all makes sense when I watch videos, I have hard time to remember these things. So what's your suggestion for making all these knowledge memory, remind it all later as well. I plan to do w3school sql tutorial as well after finishing your tutorial. But if I can get advice from you I'd appreciate.
Ive been taking and adding notes to each tutorial as i follow along in mysql and saving each tutorial as individual sql files so i can reference and review the notes whenever i want to use something in a query! Its been helpful so far. So for example from following this video i have an individual file called “window functions” that i added notes to in the code so then when i want to use window functions i can just open that file and check my notes
I am here in 2024, and I cannot help but commend you for all you do here. The sessions are quite interesting and well explained. However, I have a challenge with the first Window functions query you wrote. I wrote the same thing, but I keep getting the error "gender in field list is ambiguous."
select gender, avg(salary) over() from employee_demographics dem join employee_salary sal on dem.employee_id = sal.employee_id; this is throwing a syntax error 1064 . please help
I got it working - I had previously installed wampserver - when you open up MySQL Workbench, there were 2 options for me. I had accidentally selected the wampserver version and not the new one. Now I have the correct version and it works :)
I am learning data analytics completely on TH-cam and I must say that you guys are good❤
what other sources are you doing on TH-cam as well? would you mind sharing
@@cjbrown3396 sorry for the late reply Bro.
I also learn from simplilearn and wscube. So far so good.
@@cjbrown3396simplilearn and wscube please
@@cjbrown3396 my recommendation is not showing here. I don't really think it's allowed here
@@cjbrown3396my recommendation is not showing here and I don't really know why Bro
Awesome, thanks so much! Really appreciate seeing non-basic tutorials! Love learning new things!
The concepts are explained beautifully!
Thank you! 😊
See you all in the Advanced Series! Thank you Alex 👍
Yet another "WOW!" lesson for me. Don't think I've ever gotten to WINDOW Functions before. Very cool. I suppose it will all start to make more sense once I start using all of this on a regular basis. Am REALLY glad I figured out how to run an almost current version of MySQL on my macBook Pro in macOS Sonoma. Much simpler than using a VM, etc. Anyway, Alex's courses have always been well worth the time I invest. Thanks for putting up quality content Alex!
1st half video, I am clear about these functions. I decide to skip this video but after that I get clearance for those functions. Thank you, sir...
Extremely organized and well explained🎉
I watch this video every time I have an interview and I am just realizing that all the names in the table are characters from Parks and Recreation!! :) ❤
🙌🏽 😂 I love the sample names. Thank you for the videos!
We demand to have Lil' Sebastian next time! 🤣
Very organized, simple, and clear.
I am really glad I made it here, thank you so much Alex :)
Nice!! Whenever you have time could you make a data cleaning video?
It's coming :D
Alex the Analyst! You are the very best teacher!!!
Very good! Explained clearly, simple.Very organized!
Great video! Thanks Alex, you made something that seems quite complicated, fairly simple and easy to understand. What are some other use cases for using a Window Function? I've heard having a mastery of these is what folks in the industry use as a gauge to see if someone truly understands SQL.
I loved this session, you really kept it simple alex
I am heads down writing a book but as soon as it is done, my next career move is to add data!
Hi. On your analystbuilder the “on the way out” question, the question says to order the output from oldest to youngest but the answer that will be counted as correct has the answer as ASC. The true answer should be DESC.
No asc is correct if you do desc then you will get the top 3 youngest not oldest
DESC is oldest to youngest. ASC is youngest to oldest.
@@TheeGirl- you are not understanding the question. Let me break it down, ASC means the values are sorted from smallest to largest (vice versa for DESC). In this case, ordering by ASC for birth_date means from the earliest date (oldest) to the latest date (youngest). Therefore, using ASC will correctly order the output to identify the oldest employees first. hoped this helped
Thanks. Makes sense.
Great simple video! Thanks, Alex!
Super useful and very clearly explained. Thank you! 🙇
yeah😊
Very clear and useful
Omg I really enjoyed this lecture honestly speaking to you. Thank you 🙏🙏
Fantastic video for sure! Thank you!
Thanks Alex, I really appreciate these videos. :D
Great example explanation
So, what exactly is the advantage to doing all of the groupings / averages inside of SQL, and instead of pulling it and exporting it to Excel?
You make it so simple.
Finally understood this lesson.
Took some times, but DONE !
Thank you Alex I like your myql course
awesome!!! thank you very much, now it makes sense and i really understood it well
Hello, started the full project on "Data Cleaning", trying to INSERT layoffs_staging, with layoffs. My actions are correct but i am not getting any table. Dont know what i am doing wrong
You coulduse the using() function for joining
Useful Content and Very Well Explained.
What are the real life examples for RANK() and DENSE_RANK() functions? How to know where to use which function?
I just started learning, I hope I'm not too late?
thanks for the video!
thanks you so much alex
finally bought course today on pandas, awesome content.
But still confused should I go for SQL also?
Loving the tutorials! Quick question - I tried to put in the partition by code, it looks exactly the same as in the video, but I'm getting error code 1064. why isn't it working for me? the main issue: MySQL isn't accepting a parenthesis after OVER.
So helpful ❤❤❤❤❤❤
Sir,what level of sql solving knowledge necessary for entry level data analytics role?I am not able to build the logic to solve complex problems
the code is giving me an error, HELP!!
can someone give me the font style and size that he is using on MySQL Workbench?
Thanks Alex!
Thank you ! ❤
Thank You very Much!!
Why we add dem word with employee table and sal with salary table during join quarrt
That's an alias
Hi Alex, I watch your tutorials, it's really nice and understandable, thanks a lot. I have a problem. Despite it all makes sense when I watch videos, I have hard time to remember these things. So what's your suggestion for making all these knowledge memory, remind it all later as well. I plan to do w3school sql tutorial as well after finishing your tutorial. But if I can get advice from you I'd appreciate.
Ive been taking and adding notes to each tutorial as i follow along in mysql and saving each tutorial as individual sql files so i can reference and review the notes whenever i want to use something in a query! Its been helpful so far. So for example from following this video i have an individual file called “window functions” that i added notes to in the code so then when i want to use window functions i can just open that file and check my notes
@@imadethiscuziwsbored thanks yes I will try that
I am here in 2024, and I cannot help but commend you for all you do here. The sessions are quite interesting and well explained. However, I have a challenge with the first Window functions query you wrote. I wrote the same thing, but I keep getting the error "gender in field list is ambiguous."
window function is good
thank you
THANK YOUUU
How can you not have Ron Swanson !!! 😭
Alex please, i am following your videos 100percent; please the switch is kinda much.. from database to schema. how you got to schema windows please 😥
At the bottom of the interface there are 2 options named with administration and schema. Click on the schema then you will get the schema window
select gender, avg(salary) over()
from employee_demographics dem
join employee_salary sal
on dem.employee_id = sal.employee_id;
this is throwing a syntax error 1064 . please help
Same for me too...?
I realized it's the version of workbench- I downloaded the 8... version, but when I ran 'Select version();', it shows 5.7.31
I got it working - I had previously installed wampserver - when you open up MySQL Workbench, there were 2 options for me. I had accidentally selected the wampserver version and not the new one. Now I have the correct version and it works :)
@rheannalamph3220 sounds interesting . I am using mamp, maybe I can play around server versions too .. thank you 😊
You are different!!!
Suggest me internship?
great
✅
I did not get this lesson properly