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