select 
a.SALES_DATE as SAL_DATE , a.sales_no as NO , b.ITEM_CODE as ITEM_CODE , b.SALES_QTY as SAL_QTY , b.DELIVERED_QTY as DEL_QTY , case when b.DELIVERED_QTY = 0 then '未出荷' when b.SALES_QTY - b.DELIVERED_QTY > 0 then '一部出荷' else '出荷済' end as SHIP_STS
from 
    sales as a  left join   sales_dtl as b  on a.sales_no = b.SALES_NO
    
where 
    SALES_DATE between  '2024-04-01' and  '2024-04-10'
order by 
    1 desc , 2 asc , 3 asc