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.SALES_QTY=D.DELIVERED_QTY THEN '出荷済'
        WHEN D.DELIVERED_QTY>0 THEN '一部出荷'
        ELSE '未出荷'
    END AS SHIP_STS
FROM SALES AS S
LEFT JOIN SALES_DTL AS D
    ON S.SALES_NO=D.SALES_NO
WHERE SAL_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY SAL_DATE DESC, NO ASC, ITEM_CODE ASC;