select
    SL.SALES_DATE as "SAL_DATE",
    DTL.SALES_NO as "NO",
    DTL.ITEM_CODE as "ITEM_CODE",
    DTL.SALES_QTY as "SAL_QTY",
    DTL.DELIVERED_QTY as "DEL_QTY",
    case
        when DTL.DELIVERED_QTY = 0
            then "未出荷"
        when DTL.SALES_QTY > DTL.DELIVERED_QTY
            then "一部出荷"
        when DTL.SALES_QTY = DTL.DELIVERED_QTY
            then "出荷済"
    end as "SHIP_STS"
from SALES SL
left join SALES_DTL DTL
    on  DTL.SALES_NO = SL.SALES_NO
where SL.SALES_DATE between '2024-04-01' and '2024-04-10'
order by
    SL.SALES_DATE desc,
    DTL.SALES_NO,
    DTL.ITEM_CODE