select
    max(ORDER_AMT) as MAX_AMT
    , min(ORDER_AMT) as MIN_AMT 
from 
    TBL_ORDERS
where
    ORDER_DATE >= '2024-07-01' 
    AND ORDER_DATE <= '2024-07-07';