Supplier Showdown :Evaluate Suppliers by Number of Unique Products Supplied Intermediate

          with suppliercounts as
  (select supplierid,
          count(distinct productid) as uniqueproducts
   from products
   group by supplierid)
select supplierid,
       uniqueproducts,
       rank() over (
                    order by uniqueproducts desc) as rank
from suppliercounts;