select
    A.SALES_DATE as SAL_DATE,
    A.SALES_NO as NO,
    B.ITEM_CODE as ITEM_CODE,
    B.SALES_QTY as SAL_QTY,
    B.DELIVERED_QTY as DEL_QTY,
    CASE B.DELIVERED_QTY 
        WHEN 0 THEN '未出荷' 
        ELSE 
            CASE 
                WHEN B.SALES_QTY > B.DELIVERED_QTY THEN '一部出荷' 
                WHEN B.SALES_QTY = B.DELIVERED_QTY THEN '出荷済' 
            END
    END
    as SHIP_STS
from
    SALES as A 
join 
    SALES_DTL as B on A.SALES_NO = B.SALES_NO 
where
    A.SALES_DATE between '2024-04-01' and '2024-04-10'
order by
    A.SALES_DATE desc,
    A.SALES_NO,
    B.ITEM_CODE