Top Suppliers of the Trade Federation
Tables Used
products
ColumnType
productidbigint
nametext
descriptiontext
categorytext
pricedouble precision
supplieridbigint
stockquantitybigint
Expected Output
Column
supplierid
productcount
rank

19. Top Suppliers of the Trade Federation

Rank suppliers by the diversity of products they provide.

Xorthax wants to find the top suppliers in terms of the number of unique products they supply. Assign a row number to each supplier based on the number of unique products supplied, with the highest count ranked first.
Write Your Query