Window Functions in MySQL | Intermediate MySQL

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

[@thewryreport]

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

[@jyothsnan999]

The concepts are explained beautifully! Thank you! 😊

[@JahnaviMandava-i2n]

I really enjoyed learning this, this is how teaching should be, thank you for making learning easy❤

[@BruceBeck-f1n]

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!

[@bystander7114]

See you all in the Advanced Series! Thank you Alex 👍

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

[@rage_roxy421]

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

[@AhmdsYT]

We demand to have Lil' Sebastian next time! 🤣

[@NohablaEspnaol]

I am really glad I made it here, thank you so much Alex :)

[@swapnilbhasgauri]

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

[@darrenz2408]

Extremely organized and well explained🎉

[@raphaelmarkd]

Thank you Alex! This lesson is not that hard but a lot to absorb

[@PedramHeydarniaKohan]

Very organized, simple, and clear.

[@rohithgunda2311]

Really amazing way, you explained it. Thankyou

[@moe01]

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.

[@InspireToday797]

Alex the Analyst! You are the very best teacher!!!

[@Joseph__ebube]

Omg I really enjoyed this lecture honestly speaking to you. Thank you 🙏🙏

[@MsAisaule]

Very good! Explained clearly, simple.Very organized!

[@stephenwagude9330]

I loved this session, you really kept it simple alex

[@ProXxXify]

Super useful and very clearly explained. Thank you! 🙇

[@faisaladan3455]

yeah😊

[@katiebarnwell7278]

Great simple video! Thanks, Alex!

[@yeniramirez911]

Thanks Alex, I really appreciate these videos. :D

[@tcrawford8430]

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

[@AlexTheAnalyst]

It's coming :D

[@alienfunbug]

Fantastic video for sure! Thank you!

[@zeinh5139]

awesome!!! thank you very much, now it makes sense and i really understood it well

[@haastrupadebayoibukun6817]

Very clear and useful

[@ayazqureshi5319]

Useful Content and Very Well Explained.

[@mbmathematicsacademic7038]

Thank you Alex I like your myql course

[@dsd5705]

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

[@user-cg9hu8ox3]

So helpful ❤❤❤❤❤❤

[@abhilash6292]

Great example explanation

[@mutumakimathi]

You make it so simple.

[@yanhardichandrawan8938]

thanks for the video!

[@momohtimothy6898]

Finally understood this lesson.

[@paigemartin3827]

Here's a fun homework assignment for those of you playing with the lesson sets... First, what's missing? .. .. .. .. Ron is missing from the pool of Men! Important if you're trying to do data analysis on gender pay disparity, as is the case here. It's not uncommon to see issues like this in production where you have to clean and synthesize data from multiple tables. (Of course, in the real world, we'd be getting Ron's data added back to the demographics field, perhaps with a null for birthday) The city manager wants to make sure that Ron Swanson is included in the buildup; use a CASE statement to assign Ron to the 'Male' field. This one's surprisingly tricky because of how the partition statement sits in the order of SQL operations.

[@fightinbluhen51]

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?

[@knygrs]

Took some times, but DONE !

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

[@AkmalHidayat-zi1ve]

thanks you so much alex

[@omchaudhary8152]

Thank you ! ❤

[@tessalao5239]

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

[@Deepthipaimanoor]

Thanks Alex!

[@vighneshutamse]

What are the real life examples for RANK() and DENSE_RANK() functions? How to know where to use which function?

[@FitTechLyfe]

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

[@Jan_Be]

You coulduse the using() function for joining

[@checkYourDiet]

Thank You very Much!!

[@varunchamoli9742]

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

[@jacquelinesenechal7303]

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.

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

[@futaba6461]

THANK YOUUU

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

[@sachin-b8c4m]

thank you

[@epicvibez007]

I just started learning, I hope I'm not too late?

[@zainiichaudhry857]

the code is giving me an error, HELP!!

[@Mr.Arshad-oc1fd]

Why we add dem word with employee table and sal with salary table during join quarrt

[@janvi2294]

That's an alias

[@mullaneyduncan6018]

How can you not have Ron Swanson !!! 😭

[@wearecreatorz5688]

For some reason this made me laugh lol. I was just thinking how buddy has been missing for a couple of lessons.

[@hisokaamorou4211]

window function is good

[@omolabakeawoyemi9577]

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

[@HamdiFreh]

i just can not understand... why use always .employee_id .employee id .... Why??

[@blueedm2112]

You are different!!!

[@KasthuriarachichigePrasanna]

great

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

[@clarke6814]

✅

[@gunjisisters]

Suggest me internship?

[@abdulbaseer9643]

I did not get this lesson properly