select
    ORDER_DATE
    ,sum(ORDER_AMT) as SUM_AMT
from
    TBL_ORDERS
where
    ORDER_DATE = '2024-07-01'
group by
    ORDER_DATE;