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