SQL For Data Science | NTILE Analytical Function | Top and Bottom N Percent Customers

In this video we are going to learn a SQL analytical function called NTILE which is used in data science to create customer distribution based on sales. We will use the orders dataset to understand it via solving a problem where we need to find top 25 and bottom 25 percent customers be sales.

here is the orders dataset link:
https://docs.google.com/spreadsheets/d/1TPlQzPs9kOZkNVJO0-9Jwx01rp4VUAuM/edit?usp=sharing&ouid=106155540926582191100&rtpof=true&sd=true

Zero to hero(Advance) SQL Aggregation:
https://youtu.be/5Ighj_2PGV0

Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE

Solving 4 Trick SQL problems:
https://youtu.be/Ck1gQrlS5pQ

Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM

Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA

Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8

Playlist to master SQL :
https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb

Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk

#sql #datascience #analytics