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