Five Tiers of Product Fame :Group Products by Sales Volume into Five Popularity Tiers Intermediate

          with producttotals as
  (select p.productid,
          p.name as productname,
          sum(od.quantity) as totalquantity
   from orderdetails od
   join products p on od.productid = p.productid
   group by p.productid,
            p.name)
select productid,
       productname,
       totalquantity,
       ntile(5) over (
                      order by totalquantity desc) as popularitytier
from producttotals;