SELECT
    S.SALES_DATE AS SAL_DATE
    ,S.SALES_NO AS NO
    ,SD.ITEM_CODE AS ITEM_CODE
    ,SD.SALES_QTY AS SAL_QTY
    ,SD.DELIVERED_QTY AS DEL_QTY
    ,CASE 
        WHEN DELIVERED_QTY = 0 THEN '未出荷' 
        WHEN DELIVERED_QTY != 0 AND SALES_QTY > DELIVERED_QTY THEN '一部出荷'
        WHEN SALES_QTY = DELIVERED_QTY THEN '出荷済'
        ELSE NULL END
     AS SHIP_STS
    /*出荷数量がゼロ → '未出荷'
出荷数量がゼロ以外で、売上数量 > 出荷数量 → '一部出荷'
売上数量 = 出荷数量 → '出荷済'*/
FROM
    SALES S
    INNER JOIN
        SALES_DTL SD
    ON S.SALES_NO = SD.SALES_NO
WHERE DATE(S.SALES_DATE) BETWEEN DATE('2024-04-01') AND DATE('2024-04-10')
ORDER BY
    SAL_DATE DESC
    ,NO
    ,ITEM_CODE