select order_id,customer_name,order_date from 
(
    select order_id,customer_name,order_date,
    rank()over(partition by o.customer_id order by order_date desc) rk 
    from orders o join customers c on o.customer_id = c.customer_id
) z 
where z.rk = 1