SELECT 
    SALES.SALES_DATE AS SAL_DATE,
    SALES_DTL.SALES_NO AS NO,
    ITEM_CODE,
    SALES_QTY AS SAL_QTY,
    SALES_DTL.DELIVERED_QTY AS DEL_QTY
    FROM SALES
    
JOIN 
    SALES_DTL ON SALES.SALES_NO = SALES_DTL.SALES_NO 
WHERE 
    SAL_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY 
    SAL_DATE DESC, NO ASC, ITEM_CODE ASC;