select
    sales_date as SAL_DATE
    , sal.sales_no as NO
    , item_code as ITEM_CODE
    , sales_qty as SAL_QTY
    , delivered_qty as DEL_QTY
    , case
        when delivered_qty = 0 then '未出荷'
        when delivered_qty < sales_qty then '一部出荷'
        when delivered_qty = sales_qty then '出荷済'
        else '不明'
    end as SHIP_STS
from
    sales as sal
left join
    sales_dtl as sal_dtl
on
    sal.sales_no = sal_dtl.sales_no
where
    sales_date between '2024-04-01' and '2024-04-10'
order by
    SAL_DATE desc
    , NO asc
    , ITEM_CODE asc