SELECT
    s.sales_date AS SAL_DATE
    ,s.sales_no AS NO
    ,s2.item_code AS ITEM_CODE
    ,s2.sales_qty AS SAL_QTY
    ,s2.delivered_qty AS DEL_QTY
    ,CASE
        WHEN s2.delivered_qty = 0 THEN '未出荷'
        WHEN s2.sales_qty > S2.delivered_qty THEN '一部出荷'
        WHEN s2.sales_qty = S2.delivered_qty THEN '出荷済'
     END AS SHIP_STS
FROM
    SALES s
    INNER JOIN SALES_DTL s2
    ON s.sales_no = s2.sales_no
WHERE
      s.sales_date BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY
    s.sales_date DESC
    ,s.sales_no ASC
    ,s2.item_code ASC