SELECT
    S.sales_date AS SAL_DATE
    , S.sales_no AS NO
    , D.item_code AS ITEM_CODE
    , D.sales_qty AS SAL_QTY
    , D.delivered_qty AS DEL_QTY
    , CASE 
        WHEN D.delivered_qty = 0 
            THEN '未出荷' 
        WHEN D.delivered_qty <> 0 
        AND D.sales_qty > delivered_qty 
            THEN '一部出荷' 
        WHEN D.sales_qty = D.delivered_qty 
            THEN '出荷済' 
        END AS SHIP_STS 
FROM
    sales S 
    LEFT OUTER JOIN sales_dtl D 
        ON S.sales_no = D.sales_no 
WHERE
    sales_date BETWEEN '2024-04-01' AND '2024-04-10' 
ORDER BY
    S.sales_date DESC
    , S.sales_no ASC
    , D.item_code ASC