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