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