일자별로 합산 구하기

SELECT DATEPART(day, date_column) AS day, SUM(value_column) AS total_value
FROM table_name
GROUP BY DATEPART(day, date_column)