WINDOW FUNCTIONS | Advanced SQL

[@mo-chen]

TRY LATITUDE FOR FREE 👉 bit.ly/3o9iGlX

[@muhammadomer1654]

Really loved the way you are explaining these concepts with some business approaches + using other concepts within the window function👌

[@nhatminhtang1645]

I've always been waiting this video since the previous about SQL released. Really appreciate your help !!!

[@mo-chen]

Thanks so much for watching 😄

[@LiliaCriollo]

This is the best explanation for Window Functions, even for courses where you need to pay. Thank you

[@mo-chen]

I'm so glad you think so! Thanks for watching!

[@ardianthaputera6970]

Thanks Mo, after a while, your explanation on the OVER(PARTITION BY) query is the one that made me understood it best. Big thanks.

[@mo-chen]

I’m glad you liked it, thanks a lot for watching 😃

[@kevingonzalo9087]

nice comment

[@chrisosomo2856]

Thanks as always Mo, your explanation are always helpful. This is perhaps the best tutorial on Window Functions I have encountered so far

[@mo-chen]

Glad it was helpful! Thanks a lot for watching!

[@goodboyvincenzo]

Omg yes yes! 🎉 been waiting for this since your previous sql video! we really appreciate you, bro!!

[@mo-chen]

Thanks so much for watching Vinnyke 😄

[@offthepathworks9171]

Pretty cool, not a lot of WINDOW and analytical queries out on youtube, definitely a solid niche to be explored. Thanks 👍.

[@arneshguru4263]

Wooh! that’s some sort of content. Got my basics cleared😁.

[@mo-chen]

Glad it was helpful!

[@RafjanShawon]

You are Amazing as a Teacher

[@BaturalpAkin]

Thank you for the tips! Window functions are very important to understand especially for data analyst technical interviews.

[@mo-chen]

Thanks so much for watching Baturalp 😃 I'm glad you liked the video!

[@cionsamuel9065]

This really cleared things up for me on the topic. Thank Mo!

[@kn5372]

That was awesome. Thank you!

[@YaTianLee-j5c]

Hi Mo, thanks for yur video! This is really helpful , the content is very clear and straight forwards. Keep it up.

[@mo-chen]

That's very kind of you to say! Thanks so much for watching 😃

[@ismailsaber2759]

This is by far the best explanation of Window functions I've ever watched, thank you so much for your efforts 👏👏

[@mo-chen]

Glad it was helpful!

[@euclidasare339]

beautiful stuff. Thank you from Ghana!!

[@mocococo2877]

Thank you so so much for this nice tutorial. I can only say that it would be a bit clearer if you use ORDER BY when you used PARTITITON BY for the same column/s. Because without it results are scattered and and difficult to follow. Also. please, could you explain for your last real world example, will the column before the last be the same if you used DENSE_RANK ?? Thank you.

[@mumk]

Learned a lot in this video, thank you so much. This is much more relatable when I have years of working experience than in college

[@angelocastilloperz]

I would love to go to Japan and the US one day my friend. 💯Thanks for the content.

[@mo-chen]

Can't argue with that! I've been to California a couple of times, but would love to visit Japan myself too! Thanks a lot for watching 😃

[@Curic-Ivan]

So far the best explanation of window function! Thank you!

[@mo-chen]

Glad it helped!

[@HalpPlsxx01]

Lets go Mo!!!! Thanks for this!!! 👌👍🙏

[@mo-chen]

Great to see you again on the channel! Thanks for watching Alvin 😃

[@HalpPlsxx01]

@Data With Mo no problem bro! Always here for the rich content! I started learning SQL last week since I have a advance understanding of python now. Looking to transition and learn advance skills in SQL to land a job at at the market. 👍👌🙏

[@zakiazia8372]

one if the best tutorials on window function .. thanks a lot for your effort ..waiting for more :)

[@kastenkarsten]

This is an super amazing introduction to this topic. BIG THANKS for this! You did absolutely incredible work demonstrating this! But I have a question, which I cannot find be covered anywhere: Is it somehow possible to use value(s) from the current row and compare them them to any other row in the windows? Let's say, to stick with your example: I want to find the FIRST_VALUE booking_id over the entire resultset, whose price is 2* the price of the current row and if there is no such one, then just put a NULL in the column of the current row. Is it possible to do this using Window Functions only? Thanks in advance and best regards.

[@redhawk7773]

the bonus question can we also do like where rank

[@pablopelaez9196]

Mo, Im a huge fan of the channel! You have very good info! Just one feedback on this video. You start running without us knowing how to run 😂. Maybe for a next time a short introduction of the different type of functions and why to use them, would be great. For the rest, thanks... as always! 🤩🤩

[@Alester_edits]

please make a video on which courses we should take to be a data analyst , there's a bunch of courses and videos but we don't know which one is the absolute best and appropriate for the industry .

[@mo-chen]

Hi Alester 👋 Please check out my roadmap here datawithmo.com/. This should help 😃

[@subhraorhaw5551]

this is amazing, i was searching for these content for such a long time, Thank you MO

[@mo-chen]

Glad you found it useful! Thanks for watching 😃

[@aryashahdi2790]

Dude, you're good. Cheers!

[@MachinoLearno]

Great content. Greetings from Brazil

[@mo-chen]

hey IHAS 👋 Thanks a lot for watching!

[@CaribouDataScience]

Thanks, a lot of good info.

[@mo-chen]

Thanks for watching Caribou Data Science!

[@elfridhasman4181]

Thank you, Wow, your explanation very very Good

[@mo-chen]

Thanks so much for watching Elfrid 😁

[@peterodesola5056]

Thank you so much

[@mo-chen]

I'm glad you liked the video!

[@nikjojo]

you ever had any SQL/Python coding tests during interviews?

[@mo-chen]

Not actual coding tests but walking people through how I would solve the problems using code yes. Thanks a lot for watching!

[@kevingonzalo9087]

nice comment

[@ahmedelgendy12]

BEST OF THE BEST .. Many thx. clear & to the point

[@mo-chen]

Glad it helped!

[@grapefruitomega3517]

I’m here again for knowledge and your handsomeness - what a great deal 🤤

[@mo-chen]

Thank you so much for sticking around on the channel!

[@willmario7436]

Hello, I just wanted to ask at 24min29sec, instead of having all the code in a subquery named a and inside a query to filter the top3, wouldn't be easier to have one sole query and adding at the end a "HAVING top3_flag = "Yes" " ?

[@prashlovessamosa]

Thanks Mo

[@mo-chen]

Thanks for watching Prashant 😃

[@marialaura9493]

this is pretty cool, thanks for the video!

[@mo-chen]

Glad you liked it!

[@nikhilg9737]

perfectly explained!👌👌👌👌

[@sukriti5377]

can this be used with mysql as well????

[@Niranga.555]

Thanks for the super content...

[@mo-chen]

Thanks for watching Niranga 😃

[@mohitsahu9519]

Really helpful ❤

[@mo-chen]

Thanks so much for watching Mohit 😄

[@bellegraves]

Am I watching because I want to learn about data analytics or because he’s very handsome? Yes. The answer is yes.

[@mo-chen]

Thanks Anna 😃

[@BootyWarrior80892]

Lol 😂 same

[@manognavengala5278]

I am waiting for this one

[@mo-chen]

Nice one! Hope you liked it 😃

[@Universal-Code23.]

How I can learn Data analysis in a month fast? Please give me a roadmap.

[@mo-chen]

Please see a roadmap here datawithmo.com/

[@husseinhadliye2992]

explain the OVER Clause

[@mo-chen]

It is explained throughout the video. Please feel free to check out other learning resources if my explanation didn't get across 😁 Thanks a lot for watching!

[@nyakehkallon6597]

Big Mo 🤝.

[@mo-chen]

Thank you for watching 😃

[@YR-up8vk]

Great video as always! I would like to make a suggestion. Tbh, you could remove your face off the screen when it comes to teaching/showing things on the screen. This way, we could have a better focus on the learning and we won't be blocked from any important details we need to see.

[@mo-chen]

Thank you for watching! Noted 😃 In this video, there's nothing happening at the top right, that's why I left my face there.

[@YR-up8vk]

@@mo-chen Totally understand your motive, but it can be a little distracting for learners 😅

[@simonoganga9535]

Mine is Bora Bora Mo.

[@mo-chen]

Great to have you here on the channel Simon 😃

[@gourabsarker9552]

Sir do you earn 100000 pound sterlings a year in UK? Plz reply. Thanks a lot.

[@mo-chen]

My organisaton pays me well but I don't want to disclose how much exactly. You can find lots of salary information on Glassdoor. Thanks for watching Gourab!

[@alkitabkebenaran]

I don't think data analyst job is a bright future anymore. It will be replace by AI so quick, cause AI grow faster than we can imagine.

[@mo-chen]

Like I said, I welcome AI onboard. Being a data analyst is not just about writing code which AI is very good at. I'm more than happy for AI to do all of my boring, repetitive tasks such as data cleaning and transformation. You need to understand the business problems, engage with your stakeholders to come up with solutions, dashboards, processes that suit their needs. AI will certainly change the job tasks of data analysts, in a good way I believe - as rather than spending time doing monotonous tasks, I can spend more time doing value-add tasks.

[@ardianthaputera6970]

Hi everyone, just a quick question if anyone has any idea on this issue. I tried importing the .csv to populate the table using psql and it works all right. However, I was curious and tried to import it via "right-click on the bookings table, import/exoprt data" and got this error message: ERROR: invalid input syntax for type integer: "40.76489" CONTEXT: COPY bookings, line 9, column host_id: "40.76489" I tried exploring on why this happens and found out that postgre didn't manage to read the .csv file as well as via psql. I already made sure that every data constraints are correct, alrady check the 'header' option, and made sure the delimiter is comma (,) I'm trying to explore any possibilities to troubleshoot things myself, but ended up stuck hahaha

[@kevingonzalo9087]

nice comment