select
    SALES.SALES_DATE AS SAL_DATE,
    SALES.SALES_NO AS NO,
    SALES_DTL.ITEM_CODE AS ITEM_CODE,
    SALES_DTL.SALES_QTY AS SAL_QTY,
    SALES_DTL.DELIVERED_QTY AS DEL_QTY,
    CASE when SALES_DTL.DELIVERED_QTY=0 then '未出荷'
    when SALES_DTL.SALES_QTY > SALES_DTL.DELIVERED_QTY then '一部出荷'
    else '出荷済'
    end
        AS SHIP_STS
        from
            SALES,
            SALES_DTL
        where
            SALES.SALES_NO = SALES_DTL.SALES_NO
            AND SALES.SALES_DATE >= '2024-04-01'
            AND SALES.SALES_DATE <= '2024-04-10'
        ORDER BY
            SAL_DATE DESC,
            NO ASC,
            ITEM_CODE ASC