SELECT 
s.SALES_DATE as SAL_DATE,
s.SALES_NO as NO,
d.ITEM_CODE as ITEM_CODE,
d.SALES_QTY as SAL_QTY,
d.DELIVERED_QTY as DEL_QTY,
CASE
    WHEN d.DELIVERED_QTY= 0 THEN "未出荷"
    WHEN d.SALES_QTY >d.DELIVERED_QTY THEN "一部出荷"
    ELSE "出荷済"
END as SHIP_STS
FROM SALES s inner join SALES_DTL d on s.SALES_NO = d.SALES_NO
WHERE s.SALES_DATE >= "2024-04-01" and s.SALES_DATE < "2024-04-11"
ORDER BY SAL_DATE desc, NO, ITEM_CODE