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