select order_id
,customer_name
,order_date
from orders o 
join customers c on o.customer_id = c.customer_id
where order_date in (
    select max(order_date) as order_date
    from orders
    group by customer_id
)
group by customer_name,order_id
order by customer_name