Top Suppliers of the Trade Federation :Rank Intergalactic Suppliers by Unique Product Diversity Intermediate

          with supplierproductcounts as
  (select supplierid,
          count(distinct productid) as productcount
   from products
   group by supplierid)
select supplierid,
       productcount,
       row_number() over (
                          order by productcount desc) as supplier_num
from supplierproductcounts;