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