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