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