题解 | 每个顾客购买的最新产品名称

#三表连接
with rnk as (
    select c.customer_id,c.customer_name,p.product_name,o.order_date,row_number() over (partition by o.customer_id order by order_date DESC) as rk
    from orders as o
    left join customers as c 
    on o.customer_id = c.customer_id
    left join products as p
    on o.product_id = p.product_id
)
select customer_id,customer_name,product_name as latest_order
from rnk
where rk=1