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