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