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 > d.DELIVERED_QTY THEN '一部出荷'
        WHEN d.SALES_QTY = d.DELIVERED_QTY THEN '出荷済'
        END
    as SHIP_STS
from SALES s
    inner join SALES_DTL d
        on d.SALES_NO = s.SALES_NO
where
    s.SALES_DATE in ('2024-04-01','2024-04-02','2024-04-03','2024-04-04','2024-04-05','2024-04-06','2024-04-07','2024-04-08','2024-04-09','2024-04-10')
order by
    s.SALES_DATE desc,
    s.SALES_NO,
    d.ITEM_CODE;