The Fifth Fulfillment :Find Each Supplier’s Fifth Largest Order Contribution Intermediate

          with supplier_orders as
  (select s.supplierid,
          s.name as suppliername,
          o.orderid,
          o.ordertimestamp,
          SUM(od.quantity * od.unitprice) as supplier_order_amount
   from orderdetails od
   join orders o on od.orderid = o.orderid
   join products p on od.productid = p.productid
   join suppliers s on p.supplierid = s.supplierid
   group by s.supplierid,
            s.name,
            o.orderid,
            o.ordertimestamp)
select distinct supplierid,
                suppliername,
                NTH_VALUE(supplier_order_amount, 5) over (partition by supplierid
                                                          order by supplier_order_amount desc, orderid desc rows between unbounded PRECEDING and unbounded following) as fifthlargestorder,
                                                         NTH_VALUE(ordertimestamp, 5) over (partition by supplierid
                                                                                            order by supplier_order_amount desc, orderid desc rows between unbounded PRECEDING and unbounded following) as fifthlargestdate
from supplier_orders;