WINDOW FUNCTIONS | Advanced SQL

TRY LATITUDE FOR FREE  👉 https://bit.ly/3o9iGlX

GET YOUR DATA JOB ➡ https://mochen.info/

ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimate-data-por...

AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/ai-job-quest-lp/

PATREON ➡ Patreon: mo_chen

1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/1-1-mentorship-lp/

CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡  https://coursecareers.com/a/mochen?co...

Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ Portfolio Projects


┋Community & Socials┋

Discord: discord ⬅ Join our Discord Data Community

Instagram: mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well

LinkedIn: mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills

Twitter: mo_chen_1 ⬅ Figuring out what I want to do in this space...


┋Professional Certificates┋

CourseCareers  ➡ https://coursecareers.com/a/mochen

DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/111...

Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...

Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst

Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...

IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience

Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...


┋Timestamps┋

00:00 Intro
01:50 Import csv files
03:06 CREATE TABLE
04:18 psql command line tool
08:02 OVER
11:12 PARTITION BY
14:56 ROW_NUMBER
18:00 RANK and DENSE_RANK
20:38 LAG and LEAD
24:20 Bonus
25:23 Outro


┋The project┋

Github repo for code ➡ https://github.com/mochen862/window-f...

New York City Airbnb Open Data ➡ https://www.kaggle.com/datasets/dgomo...

Thanks so much for taking a little time out of your day to watch this!