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