Product Pairs in Category Time :Analyze Consecutive Product Sales and Category-Based Order Sequences Intermediate

          select o.orderid,
       od.orderdetailid,
       o.ordertimestamp,
       p.category,
       p.name as productname,
       lead(p.name) over (partition by p.category
                          order by o.ordertimestamp,
                                   o.orderid,
                                   od.orderdetailid) as nextproduct
from orderdetails od
join orders o on od.orderid = o.orderid
join products p on od.productid = p.productid
where o.ordertimestamp >= '2245-03-01'
  and o.ordertimestamp < '2245-04-01';