select order_id,customer_name,order_date
from

(select order_id,customer_name, order_date,row_number() over (partition by customer_id order by order_date desc) as rk 
from orders
join customers
using(customer_id)) as t
where rk =1
order by customer_name