Supplier Pricing Percentiles
Tables Used
products
ColumnType
productidbigint
nametext
descriptiontext
categorytext
pricedouble precision
supplieridbigint
stockquantitybigint
suppliers
ColumnType
supplieridbigint
nametext
originplanettext
contactinfotext
ratingdouble precision
Expected Output
Column
supplierid
suppliername
averageprice
pricingpercentrank

64. Supplier Pricing Percentiles

Determine where each supplier falls in percent rank by average price.

Xorthax wants to evaluate suppliers based on the percent rank of their average product price. Write a query to calculate this rank for each supplier.
Write Your Query