Window Functions in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Window Functions in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@thewryreport]

Awesome, thanks so much! Really appreciate seeing non-basic tutorials! Love learning new things!

[@jyothsnan999]

The concepts are explained beautifully! Thank you! 😊

[@user-dq6eg6yq3j]

Very organized, simple, and clear.

[@katiebarnwell7278]

Great simple video! Thanks, Alex!

[@rage_roxy421]

🙌🏽 😂 I love the sample names. Thank you for the videos!

[@dineshchellaiahc4588]

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

[@ProXxXify]

Super useful and very clearly explained. Thank you! 🙇

[@user-kq3tc5tu1c]

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!

[@alienfunbug]

Fantastic video for sure! Thank you!

[@yeniramirez911]

Thanks Alex, I really appreciate these videos. :D

[@ayazqureshi5319]

Useful Content and Very Well Explained.

[@momohtimothy6898]

Finally understood this lesson.

[@Deepthipaimanoor]

Thanks Alex!

[@mutumakimathi]

You make it so simple.

[@emmanuel.mireku]

I am learning data analytics completely on KZbin and I must say that you guys are good❤

[@cjbrown3396]

what other sources are you doing on KZbin as well? would you mind sharing

[@emmanuel.mireku]

@@cjbrown3396 sorry for the late reply Bro. I also learn from simplilearn and wscube. So far so good.

[@emmanuel.mireku]

​@@cjbrown3396simplilearn and wscube please

[@emmanuel.mireku]

​@@cjbrown3396 my recommendation is not showing here. I don't really think it's allowed here

[@emmanuel.mireku]

​@@cjbrown3396my recommendation is not showing here and I don't really know why Bro

[@user-cg9hu8ox3]

So helpful ❤❤❤❤❤❤

[@user-zf3it3vw2e]

thank you

[@varunchamoli9742]

finally bought course today on pandas, awesome content. But still confused should I go for SQL also?

[@dsd5705]

I am heads down writing a book but as soon as it is done, my next career move is to add data!

[@tcrawford8430]

Nice!! Whenever you have time could you make a data cleaning video?

[@AlexTheAnalyst]

It's coming :D

[@MHb789]

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

[@travis37115]

can someone give me the font style and size that he is using on MySQL Workbench?

[@TheeGirl-]

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.

[@fuzzwar]

No asc is correct if you do desc then you will get the top 3 youngest not oldest

[@TheeGirl-]

DESC is oldest to youngest. ASC is youngest to oldest.

[@fuzzwar]

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

[@TheeGirl-]

Thanks. Makes sense.

[@ozgunc4735]

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.

[@imadethiscuziwsbored]

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

[@ozgunc4735]

@@imadethiscuziwsbored thanks yes I will try that

[@blueedm2112]

You are different!!!

[@akintimehinmoromoke]

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 😥

[@minhajabedin3532]

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

[@JigarShah-gk3ew]

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

[@rheannalamph3220]

Same for me too...?

[@rheannalamph3220]

I realized it's the version of workbench- I downloaded the 8... version, but when I ran 'Select version();', it shows 5.7.31

[@rheannalamph3220]

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 :)

[@JigarShah-gk3ew]

@rheannalamph3220 sounds interesting . I am using mamp, maybe I can play around server versions too .. thank you 😊

[@gunjisisters]

Suggest me internship?