WINDOW FUNCTIONS | Advanced SQL

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

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! 🤩🤩

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.

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

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

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

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

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

this is pretty cool, thanks for the video!

explain the OVER Clause

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

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

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

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

Great content. Greetings from Brazil

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

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.

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

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

Thank you, Wow, your explanation very very Good

Mine is Bora Bora Mo.

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 .

Really helpful ❤

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

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

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.

Thanks, a lot of good info.

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

Thanks Mo

I am waiting for this one

Big Mo 🤝.

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

Thanks for the super content...

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