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';