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 DELIVERED_QTY = 0 THEN '未出荷' 
       WHEN DELIVERED_QTY != 0 AND SALES_QTY > DELIVERED_QTY THEN '一部出荷'
       WHEN SALES_QTY = DELIVERED_QTY THEN '出荷済'
  END)  AS  SHIP_STS  
 FROM SALES 
 LEFT JOIN SALES_DTL
 on SALES.SALES_NO = SALES_DTL.SALES_NO
 Where
  SAL_DATE <= '2024-04-10' and
  SAL_DATE >= '2024-04-01'
 ORDER BY SAL_DATE DESC ,NO ASC ,ITEM_CODE ASC