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