SELECT
 ORDER_DATE,
 SUM(ORDER_AMT) AS SUM_AMT
  
FROM
 TBL_ORDERS
 
WHERE
 ORDER_DATE = '2024-07-01'
 
GROUP BY
 ORDER_DATE;