select
    order_date
    ,SUM(order_amt) as SUM_AMT
from tbl_orders
where order_date = '2024-07-01'

;