select SALES_DATE  as SAL_DATE, SALES_NO as NO, ITEM_CODE, SALES_QTY as SAL_QTY, DELIVERED_QTY as DEL_QTY, 
(case when DELIVERED_QTY == 0 then "未出荷" when SALES_QTY > DELIVERED_QTY then "一部出荷" else "出荷済" end) as SHIP_STS
from SALES
left outer join SALES_DTL using (SALES_NO)
where "2024-04-01" <= SALES_DATE and SALES_DATE <= "2024-04-10"
order by SALES_DATE desc, SALES_NO, ITEM_CODE