SELECT
    SA.SALES_DATE AS SAL_DATE
    , SA.SALES_NO AS NO
    , SAD.ITEM_CODE AS ITEM_CODE
    , SAD.SALES_QTY AS SAL_QTY
    , SAD.DELIVERED_QTY AS DEL_QTY
    , CASE 
        WHEN DELIVERED_QTY=0 THEN '未出荷'
        WHEN DELIVERED_QTY<>0 and SALES_QTY>DELIVERED_QTY THEN '一部出荷'
        WHEN SALES_QTY=DELIVERED_QTY THEN '出荷済'
        ELSE NULL
	END AS SHIP_STS
FROM SALES AS SA
    INNER JOIN SALES_DTL AS SAD
        ON SA.SALES_NO = SAD.SALES_NO
where SAL_DATE between '2024-04-01' AND '2024-04-10'
ORDER BY
    NO DESC
    ,SAL_DATE ASC
    , ITEM_CODE ASC;