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 '出荷済' 
else 'test' end as 'SHIP_STS' from SALES 
inner join SALES_DTL on SALES.SALES_NO = SALES_DTL.SALES_NO where SALES_DATE >= '2024-04-01' and SALES_DATE <= '2024-04-10'
order by SALES_DATE desc,SALES.SALES_NO asc,ITEM_CODE asc;