select SALES.SALES_DATE as SAL_DATE, SALES.SALES_NO as NO, SALES_DTL.ITEM_CODE, SALES_DTL.SALES_QTY as SAL_QTY, SALES_DTL.DELIVERED_QTY as DEL_QTY 
    from SALES 
    inner join SALES_DTL on SALES.SALES_NO = SALES_DTL.SALES_NO
    where SAL_DATE between "2024-04-01" and "2024-04-30"
    case 
        when DEL_QTY = 0 then "未出荷"
        when SAL_QTY > DEL_QTY then "一部出荷"
        when SAL_QTY = DEL_QTY then "出荷済"
    end as SHIP_STS
    order by SAL_DATE desc, NO asc, ITEM_CODE asc;