select
    max(order_amt) as MAX_AMT
    ,min(order_amt) as MIN_AMT
from
    tbl_orders
where
    order_date >= '2024-07-01' and '2024-07-07'>= order_date;