SELECT
     SAL.SALES_DATE       AS SAL_DATE
    ,SAL.SALES_NO         AS NO
    ,SALDTL.ITEM_CODE     AS ITEM_CODE
    ,SALDTL.SALES_QTY     AS SAL_QTY
    ,SALDTL.DELIVERED_QTY AS DEL_QTY
    ,CASE
        WHEN SALDTL.DELIVERED_QTY = 0 THEN '未出荷'
        WHEN SALDTL.DELIVERED_QTY <> 0 AND SALDTL.DELIVERED_QTY < SALDTL.SALES_QTY THEN '一部出荷'
        WHEN SALDTL.DELIVERED_QTY = SALDTL.SALES_QTY THEN '出荷済'
        ELSE NULL END               AS SHIP_STS
FROM SALES AS SAL
INNER JOIN SALES_DTL AS SALDTL
    ON  SALDTL.SALES_NO  = SALDTL.SALES_NO
WHERE   SAL.SALES_DATE >= '2024-04-01'
    AND SAL.SALES_DATE <= '2024-04-10'
ORDER BY
     SAL.SALES_DATE DESC
    ,SAL.SALES_NO
    ,SALDTL.ITEM_CODE
;