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