select
sales.sales_date as SAL_DATE
, sales.SALES_NO as NO
, dt.ITEM_CODE as ITEM_CODE
, dt.SALES_QTY as SAL_QTY
, dt.DELIVERED_QTY as DEL_QTY
, case 
when dt.DELIVERED_QTY = 0 then '未出荷'
when dt.SALES_QTY > dt.DELIVERED_QTY then '一部出荷'
else '出荷済' end as SHIP_STS
from sales join sales_dtl as dt on sales.sales_no = dt.sales_no
where sales.sales_date between '2024-04-01' and '2024-04-10'
order by sal_date desc, no, ITEM_CODE