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

SELECT
    o.customer_id,
    c.customer_name,
    p.product_name AS latest_order
FROM
    orders AS o
    INNER JOIN
    customers AS c ON o.customer_id=c.customer_id
    INNER JOIN
    products AS p ON o.product_id=p.product_id
WHERE
    o.order_date IN (
        SELECT
            MAX(order_date)
        FROM
            orders
        GROUP BY
            customer_id
    )
ORDER BY
    o.customer_id;