SELECT SALES.SALES_DATE AS SAL_DATE, SALES.SALES_NO AS NO, SALES_DTL.ITEM_CODE AS ITEM_CODE, SALES_DTL.SALES_QTY AS SAL_QTY, SALES_DTL.DELIVERED_QTY AS DEL_QTY
, CASE 
    WHEN SALES_DTL.DELIVERED_QTY = 0 THEN "未出荷"
    WHEN SALES_DTL.DELIVERED_QTY <> 0 AND SALES_DTL.SALES_QTY > SALES_DTL.DELIVERED_QTY THEN "一部出荷"
    WHEN SALES_DTL.SALES_QTY = SALES_DTL.DELIVERED_QTY THEN "出荷済"
  END AS SHIP_STS 
FROM SALES INNER JOIN SALES_DTL ON SALES.SALES_NO = SALES_DTL.SALES_NO
WHERE INSTR(SAL_DATE, "2024-04-0") OR INSTR(SAL_DATE, "2024-04-10") 
ORDER BY SAL_DATE DESC, NO ASC, SALES_DTL.ITEM_CODE ASC