SELECT 
    s.sales_date AS SAL_DATE,
    s.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.delivered_qty = sd.sales_qty THEN '出荷済'
        WHEN sd.delivered_qty <> 0 AND sd.sales_qty > sd.delivered_qty THEN '一部出荷'
    END AS STATUS
FROM
    sales AS s
    JOIN sales_dtl AS sd
    ON s.sales_no = sd.sales_no
WHERE 
    s.sales_date BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY
    s.sales_date DESC, s.sales_no ASC, sd.item_code asc;