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