select 
SALES_DATE as SAL_DATE,
SALES.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 != 0 and SALES_QTY > DELIVERED_QTY then '一部出荷'
when SALES_QTY = DELIVERED_QTY then '出荷済'
end as SHIP_STS

from SALES
inner join SALES_DTL
on SALES_DTL.SALES_NO = SALES.SALES_NO

where SALES_DATE between '2024-04-01' and '2024-04-10'

order by SAL_DATE desc, NO asc, ITEM_CODE asc