select
    SA.SALES_DATE as SAL_DATE,
    SA.SALES_NO as NO,
    SD.ITEM_CODE as ITEM_CODE,
    SD.SALES_QTY as SAL_QTY,
    SD.DELIVERED_QTY as DEL_QTY,
    CASE 
        WHEN SD.DELIVERED_QTY = 0 
            THEN '未出荷' 
        WHEN SD.SALES_QTY > SD.DELIVERED_QTY 
            THEN '一部出荷' 
        WHEN SD.SALES_QTY = SD.DELIVERED_QTY 
            THEN '出荷済' 
        ELSE NULL 
        END AS SHIP_STS
from
    SALES as SA
    INNER JOIN SALES_DTL as SD
    on SA.SALES_NO=SD.SALES_NO
where 
    SA.SALES_DATE BETWEEN '2024-04-01' and '2024-04-10'
order by
    SAL_DATE desc,
    NO asc,
    ITEM_CODE asc