SELECT s.SALES_DATE AS SAL_DATE, s.SALES_NO AS NO, sd.ITEM_CODE AS ITEM_CODE, sd.SALES_QTY AS SAL_QTY, sd.DELIVERED_QTY AS DEL_QTY, 
CASE WHEN DELIVERED_QTY = 0 THEN "未出荷" WHEN SALES_QTY > DELIVERED_QTY THEN "一部出荷" ELSE "出荷済" END AS SHIP_STS
FROM SALES as s, SALES_DTL as sd
WHERE s.SALES_DATE BETWEEN "2024-04-01" AND "2024-04-10"
AND sd.SALES_NO = s.SALES_NO
ORDER BY s.SALES_DATE DESC, s.SALES_NO, sd.ITEM_CODE;