select order_id,customer_name,order_date
from (
    select customer_id,max(order_date) as order_date
    from orders
    group by customer_id
)temp join customers using(customer_id) join orders using(order_date)
order by customer_name;