select
    max(order_amt) MAX_AMT
    ,MIN(order_amt) MIN_AMT
from
    tbl_orders
where
    order_date between '2024-07-01' and '2024-07-07'
;