Latest Order per Customer

SELECT customer_id, id AS order_id, total, order_date
FROM (
    SELECT o.*,
           ROW_NUMBER() OVER (PARTITION BY o.customer_id ORDER BY o.order_date DESC) AS rn
    FROM orders o
) AS ranked
WHERE rn = 1;