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.sales_qty = 0 THEN '未出荷'
        when sd.sales_qty > sd.delivered_qty THEN '一部出荷'
        when sd.sales_qty = sd.delivered_qty THEN '出荷済'
    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' 
ORDER BY
    sa.sales_date DESC,
    sa.sales_no,
    sd.item_code