select
    order_date
    ,sum(order_amt) as SUM_AMT
from
    tbl_orders
where
    order_date = '2024-07-01'
group by
    order_date;