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