Percentage, Quantiles, Percentiles, Ntiles Window functions in SQL

We have learnt the Rank, Dense_rank, Row_number in the Introduction to windows functions. First_value, Last_value, Lag and Lead window…