select
order_id,
customer_name,
order_date
from (
select
order_id,
customer_id,
order_date,
row_number() over(partition by customer_id order by order_date desc) as rn
from orders
) t1
left join customers t2 on t1.customer_id = t2.customer_id
where t1.rn = 1

;