PERCENT_RANK analytic function in SQL Server

Playlist - https://www.youtube.com/watch?v=Nhcgs0bNshE&list=PLdnPqkBptCEITvVQtcOmKUgA7xT6Fqixc
------------------------------------------------------------------------------------------
CUME_DIST() - https://youtu.be/Nhcgs0bNshE
PERCENT_RANK() - https://youtu.be/Kd6coeQN8Y4
FIRST_VALUE() - https://youtu.be/nCl01TIseZs
LAST_VALUE() - https://youtu.be/NnMH-TU-BU4
LEAD() - https://youtu.be/_DlXcVW_axA
LAG() - https://youtu.be/1yt2f4k5DAM
PERCENTILE_CONT() - https://youtu.be/0VwRl5geLOs
PERCENTILE_DISC() - https://youtu.be/KJborDiUvNk
------------------------------------------------------------------------------------------
QUERY SOLVE -
1. What is analytic functions in SQL Server?
2. What is PERCENT_RANK analytic functions in SQL Server?
3. Syntax of PERCENT_RANK analytic functions?
4. What is partition by clause in SQL Server?
5. What is Order by clause in SQL Server?
6. Default parameters of PERCENT_RANK analytic functions in SQL Server?

PERCENT_RANK()
------------------------------
The PERCENT_RANK analytic function calculates the relative rank of a row within a group of rows. Use PERCENT_RANK to evaluate the relative standing of a value within a query result set or partition. PERCENT_RANK is similar to the CUME_DIST function.
The range of values returned by PERCENT_RANK is greater than 0.0 and less than or equal to 1.0. The first row in any set has a PERCENT_RANK of 0. NULL values are included by default and are treated as the lowest possible values.

Syntax :
PERCENT_RANK( )
OVER ( [ partition_by_clause ] order_by_clause )

Formula :
PERCENT_RANK() = (Row number – 1) / (Total Rows – 1)

Query:
SELECT [Name],
Make,
Model,
Price,
[Type],
PERCENT_RANK () over (PARTITION BY [TYPE] ORDER BY price) as PERCENT_RANK_PARTITION
FROM [Bikes]

Thanks for watching this video.