SELECT SALES_DATE AS SAL_DATE,s1.SALES_NO AS NO,ITEM_CODE,SALES_QTY,DELIVERED_QTY AS DEL_QTY FROM SALES AS s1 INNER JOIN SALES_DTL AS s2 ON s1.SALES_NO=s2.SALES_NO WHERE SAL_DATE BETWEEN '2024-04-01 00:00:00' AND '2024-04-10 23:59:59' ORDER BY SAL_DATE DESC,NO ASC,ITEM_CODE ASC