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