이관 주문 - 전건 대조

SELECT o.legacy_wp_id, o.status, o.total_sell_amount, o.created_at,
       u.name,
       (SELECT count(*) FROM order_items oi WHERE oi.order_id = o.id) AS 항목수,
       (SELECT sum(dd.cost_amount) FROM driver_dispatches dd
         WHERE dd.order_id = o.id) AS 배차정산
FROM orders o LEFT JOIN users u ON u.id = o.user_id
ORDER BY o.total_sell_amount DESC NULLS LAST;   -- 신규(PostgreSQL)