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
WHERE INSTR(SALES_DATE, "2024-04-0") OR INSTR(SALES_DATE, "2024-04-10") 
ORDER BY SALES_DATE DESC, SALES.SALES_NO ASC, ITEM_CODE ASC