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