Supplier Pricing Pyramid
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
pricingtier

37. Supplier Pricing Pyramid

Divide suppliers into 3 pricing bands based on average product cost.

Xorthax is evaluating suppliers based on the average price of the products they supply. Divide suppliers into 3 pricing tiers.
Write Your Query