SELECT MAX(ORDER_AMT) MAX_AMT,MIN(ORDER_AMT) MIN_AMT
FROM TBL_ORDERS
WHERE ORDER_DATE BETWEEN '2024-07-01' AND '2024-07-08';