Session 37 (Cont..) - Window Functions Part 3 | SQL Tutorial
Channel: CampusX
Date: 2023-03-02

Code -https://docs.google.com/document/d/1PyAU4tBcBxUR5Vn4GEZngPJXkKArAHqUBZgCCu1fFk4/edit?usp=sharing

Datasets: https://drive.google.com/drive/folders/1N3WzcWpwiYwxobFIlNn9sOHVRZ-tpBdc?usp=share_link

Task 37 - https://colab.research.google.com/drive/1YpfaSlmAg8NPqTJzR0piPOIzKk0ZWZx0?usp=sharing

Window Functions Part-1 Pdf : https://drive.google.com/file/d/12P7vW2VBq0_4Nm3j1aQDB599HOy0OGtk/view?usp=share_link
Window Functions Part-2&3 Pdf : https://drive.google.com/file/d/1pTPslw_dOMwkK06Cu-lcHX5NzRtmNPW5/view?usp=share_link
============================
Do you want to learn from me?
Check my affordable mentorship program at : https://learnwith.campusx.in
============================

📱 Grow with us:
CampusX' LinkedIn: https://www.linkedin.com/company/campusx-official
CampusX on Instagram for daily tips: https://www.instagram.com/campusx.official
My LinkedIn: https://www.linkedin.com/in/nitish-singh-03412789
Discord: https://discord.gg/PsWu8R87Z8

⌚Time Stamps⌚

00:00 Start
00:59 Percent Change
13:12 Percentage change for a specific window
16:06 Quantiles/Percentiles - percentile_disc
21:43 PERCENTILE_CONT
31:45 Segmentation
41:32 Cumulative Distribution
47:54 Partition By Multiple Columns
52:43 End