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'
    -- sa.sales_date >= '2024-04-01' and sa.sales_date <= '2024-04-10' 
ORDER BY
    sa.sales_date DESC,
    sa.sales_no asc,
    sd.item_code asc