select SALES.SALES_DATE SAL_DATE, SALES.SALES_NO NO, SALES_DTL.ITEM_CODE ITEM_CODE, SALES_DTL.SALES_QTY SAL_QTY, SALES_DTL.DELIVERED_QTY DEL_QTY, 
case when SALES_DTL.DELIVERED_QTY = 0 then '未出荷' when SALES_DTL.SALES_QTY > SALES_DTL.DELIVERED_QTY then '一部出荷' when SALES_DTL.SALES_QTY = SALES_DTL.DELIVERED_QTY then '出荷済' else '' end as 'SHIP_STS'
from SALES 
inner join SALES_DTL 
on SALES_DTL.SALES_NO = SALES.SALES_NO 
where SALES.SALES_DATE between '2024-04-01' and '2024-04-10'
order by SAL_DATE desc, NO, ITEM_CODE;