select
    SALES_DATE SAL_DATE,
    S.SALES_NO NO,
    ITEM_CODE as ITEM_CODE,
    SALES_QTY SAL_QTY,
    DELIVERED_QTY DEL_QTY,
    case when DELIVERED_QTY = 0 then '未出荷'
when SALES_QTY > SD.DELIVERED_QTY then '一部出荷'
else '出荷済' end as SHIP_STS



from SALES S join SALES_DTL SD on S.SALES_NO = SD.SALES_NO
where S.SALES_DATE between '2024-04-01' and '2024-04-10'

order by 1 desc,2 ,3